Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Storing a range variable in a cell
I am writing a VBA script and I need to frequently load and store a range as
a long-term variable. How do I store an actual range as a variable so that I can have a function load it and save it? I need to do this because I am using the Application.OnTime function and will need to call a subroutine to execute a complex series of actions. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Storing a range variable in a cell
Just put someything like Sheet1!A1:M10 in the cell as use
Set myRange = Range(Worksheets("Sheet1").Range("A1").Value) -- __________________________________ HTH Bob "Dreaded404" wrote in message ... I am writing a VBA script and I need to frequently load and store a range as a long-term variable. How do I store an actual range as a variable so that I can have a function load it and save it? I need to do this because I am using the Application.OnTime function and will need to call a subroutine to execute a complex series of actions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Cell Range Reference | Excel Worksheet Functions | |||
VLOOKUP variable range cell reference | Excel Worksheet Functions | |||
Finding max array value of variable cell range | Excel Discussion (Misc queries) | |||
Storing a value to variable | Excel Discussion (Misc queries) | |||
Variable Determines Number of Cell in Formula Range | Excel Worksheet Functions |