| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return array of page ranges
Using Windows XP and Office 2003.
Hi, I need a function that will retrieve the range address of each defined page range on a sheet. For example, if page one is set to A2:H50, and page two is set to A51:H80, I need to retrieve each of these sets of ranges. The number of pages may vary at different times. I would prefer to work with an array if possible. Your assistance in the form of example code would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
| Return all page ranges in an array? (Repost - Tom?) | Excel Programming | |||
| Return an array of all page ranges in a sheet? | Excel Programming | |||
| variant array containing cel adresses convert to actual ranges-array | Excel Programming | |||
| Array of page ranges | Excel Programming | |||
Threaded Mode
