| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a macro to do a calculation
I have the following macro, but how do make it so it will do the calculation
for any cell I select instead of just the original cell? Range("F14").Select ActiveCell.FormulaR1C1 = "=IF(RC[-4]=""nv71pull"",(RC[-1]/192),(RC[-1] /150))" Thanks in advance for the help Bill R. God Bless -- John 3:16 "For God so loved the world that He gave His only begotten Son, so that whoever believes in Him shall not parish, but have eternal life" Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200708/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If VBA Macro for Tiered Calculation | Excel Discussion (Misc queries) | |||
| Macro Help for a BIG Calculation | Excel Discussion (Misc queries) | |||
| Product calculation macro | New Users to Excel | |||
| MACRO TO SET THE AUTOMATIC CALCULATION | Excel Discussion (Misc queries) | |||
| Run a macro when cell changes (due to calculation!) | Excel Programming | |||
Threaded Mode
