Haim,
Try ...
1. Dim K as Double '(Double-precision floating point)
2. As above. Calculate your percentages as decimals and format the output
cell in your spreadsheet as percentage
3. K = activecell.value
4. activecell.value = K
I hope that this helps
"Haim" wrote:
Hi,
I'm working with VB.
How can I do the following with VB commands:
1. Declare K (variable) as a regular number
2. Declare K as percentage variable
3. (Variable) K = Current Cell
4. Current Cell = (Variable) K
Thank you,
Haim.