| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that uses range names
I am looking to create a simple macro. I have created some range names,
example is page1 all the way to page10. I want to copy these ranges to another worksheet. The problem is my macro is only good if I know how many range pages that I will actually need. I want to know how I can create a loop that will work for 1 page or 100 pages. -- Mr Speedy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference Range Names in Macro | Excel Discussion (Misc queries) | |||
| Macro and range names | Excel Programming | |||
| Using range names in a macro formula | Excel Programming | |||
| Macro for Range Names | Excel Programming | |||
Threaded Mode
