| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a variable in a formula
Hi,
I am trying to use a range variable in a formula for a cell. The code i have currently is: rct = Selection.CurrentRegion.Rows.Count + 3 Range("e" & rct + 1).Formula = "=sum("e5:e" & rct)" The rows would vary depending on sheets used. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using a variable in a formula
Never mind. Realised my mistake soon after posting :)
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter variable data into a formula | Excel Discussion (Misc queries) | |||
| use of variable in formula / execute4excel | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
