View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eastar Eastar is offline
external usenet poster
 
Posts: 6
Default 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