Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
you have a great memory, rowan<g
-- Gary "Rowan Drummond" wrote in message ... Which is not that far off the answer Simon gave back in August <g. Kalpesh wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA - variable declaration | Excel Discussion (Misc queries) | |||
External Variable Declaration | Excel Programming | |||
External Variable Declaration | Excel Programming | |||
Global variable declaration! | Excel Programming | |||
Variable Declaration?? | Excel Programming |