dim it as double

--


Gary Keramidas
Excel 2003


"laavista" wrote in message
...
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