| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting formulas depending on a variable
It is possible to insert a formula in the cell by Formula property, for
instance: Range("A1") Formula = "=Sum(A2:A12)" How can I to change cells which are used in formula, depending on a variable. For instance, I need to change the range A2:A12 to Ax:Ay depending on variable - rng=Range("Ax:Ay") ? I am using Excel2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add a variable range of columns depending on criteria | Excel Worksheet Functions | |||
| Please help - subtotal using vlookup depending on variable month | Excel Discussion (Misc queries) | |||
| How do I sort between worksheets depending on variable | Excel Worksheet Functions | |||
| Inserting a Date depending on a spereate Cell Value | Excel Discussion (Misc queries) | |||
| Inserting # of rows depending on value in Column | Excel Programming | |||
Threaded Mode
