How to prevent cell rounding

I am using the following code to run through up to 100 locations and create a result in column E. Initially this worked fine, but now it is rounding numbers. For example in column B, I may have a value of 175.61 and in column C a value of 350.00. I am trying to subtract column B from column C and get the results of 174.39 that is posted in column E. However, the result in rounding the number to just 174.00 not showing the remainder in column E.

My code is

Please Login or Register  to view this content.

Any idea how I can stop this? Column E is formated with 2 decimal places.

Well I just resolved it by changing the the cvalue from integer and declaring it as a double. Dim cvalue as Double. It now work fine.

You need to declare cvalue as double not integer.