Prev: Run Time Error on trying to save workbook
Next: Paste Value Toolbar Icon
From: laavista on 2 Feb 2010 21:07
I found the answer. I need to dim as "single"...


"laavista" wrote:

> I need to store the value of a percent in a variable.
>
> The value in the cell is 48.4%.
> If I change the format to a number it's
> 0.484320557491289
>
> I've tried
> dim ThePrecentage as long (I get a value of 0)
> dim ThePercentage as integer (I get a value of 0)
> dim ThePercentage as text (just to see what I got-- I got
> "0.484320557491289"
>
> Later in the procedure I will be checking to see in what range the
> percentage falls, e.g., 0-39.9; 40.0 to 49.9 or 50.0+
>
> Any help you can provide would be VERY appreciaed
 | 
Pages: 1
Prev: Run Time Error on trying to save workbook
Next: Paste Value Toolbar Icon