Decimal Problem in Macro

[toolpusher]

Hi I have a macro that compares the increasing values in Col A and writes the difference in value of these compared to the first value in Col A in Col B. This works fine as long as the first number is a whole number. If not it just rounds it up or down. I need it to give me the answer to two decimal places. Heres the code

Please Login or Register  to view this content.

Any help with this would be great

John

[jasoncw]

My guess is it has something to do with declaring a as an integer. Try declaring a As Double, and see if it helps.

[toolpusher]

Jason

Thanks for the help macro works fine now

regards

John