Prev: Autofill
Next: Move data from Doc1 to Doc2, end with 2nd doc open
From: petedacook on 25 Feb 2010 09:52
This seems easy enough but I cannot figure out the code and I cannot find an
example.

I need to round cells so there is 2 decimal places. I just need standard
rounding so there is no more than 2 decimal places.

This is what I did, but i cannot get it working.


Do While I <= 50
round(cells(I,3).value,2)
I = I + 1
Loop

or

Do While I <= 50
round(cells(I,3),2)
I = I + 1
Loop

And I have tried several other variations.....but I cannot get anything to
work.

Thanks,

Pete
From: petedacook on 25 Feb 2010 10:16
I apologize.......I see this was answered.....I have been having trouble with
the forums lately.
 | 
Pages: 1
Prev: Autofill
Next: Move data from Doc1 to Doc2, end with 2nd doc open