View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kalpesh[_2_] Kalpesh[_2_] is offline
external usenet poster
 
Posts: 15
Default A disturbing behaviour of DIM (for variable declaration)

Hi David,

The reason being - when an integer is multiplied with another integer,
it will return an integer
So, 4 * 10000 (in your case) will make it 40000 & it will try to put
that result in a temporary integer variable (before assigning it to p
- which is long)

So, change your expression to p = clng(x) * 10000
Here, you are telling that multiply a long by an integer

Alternatively, you could write x * 10000.0 (this will make it a double
data type)

HTH
Kalpesh