| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Storing multiple ranges using a macro
I have to play with lot of ranges in a worksheet. Say range1 is from
A1:A10, range2 is from B1:B10 and so on. I have 1000s of such ranges. One of doing it is defining individial ranges say dim range1 as range dim range2 as range ..... .... .... etc. I dont want to use 1000 variables for 1000 different ranges. Is there any way of creating an array of ranges? OR Whats the best way of doing it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Storing multiple ranges using a macro | Excel Discussion (Misc queries) | |||
| Record macro to name multiple ranges | Excel Programming | |||
| Macro Help (Uppercase multiple ranges?) | Excel Discussion (Misc queries) | |||
| Print macro for multiple ranges/sheets | Excel Programming | |||
| Print macro for multiple ranges/sheets | Excel Programming | |||
Threaded Mode
