| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand Range
If your range is held within a variable, it will not be saved.
But, I managed to get around this. Put your variable in an empty cell of the spreadsheet, and then make your sub look at this cell at the begining and reassign the value of the cell back to the variable. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| So frustrated. All I need to do is expand a simple range :( | Excel Discussion (Misc queries) | |||
| Expand a Named Range in 2007 | New Users to Excel | |||
| Range that expand | Excel Discussion (Misc queries) | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| Data Range Will Not Expand | Excel Worksheet Functions | |||
Hybrid Mode
