Pls help on Macro - round formula
A small data base
A B
1 3.3456 6.3535
2 4.5656 10.3265
Want to set up a macro to round the data,Macro as below
Range("d1:e2").Select
Selection.Formula = "ROUND(RC[-3],2)
The result I got is ROUND(RC[-3],2), instead of numbers (3.35, 6.36 .etc.)
thanks
|