| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How not to round a formula | Excel Discussion (Misc queries) | |||
| Round up Formula Help | Excel Discussion (Misc queries) | |||
| How do I NOT round off in a formula | Excel Worksheet Functions | |||
| formula to round up? | Excel Worksheet Functions | |||
| using a macro round function | New Users to Excel | |||
Threaded Mode
