| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
return what page a named range is on
I have a sheet with 40 named ranges in it.
I would like to make a "table of contents" of this sheet that would have the name of the range in a column and in the next could the page its on (all automatic page breaks) anyone have some code that can do this ??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
return what page a named range is on
Insert = Name = Paste = Paste List
"Chris Salcedo" wrote in message oups.com... I have a sheet with 40 named ranges in it. I would like to make a "table of contents" of this sheet that would have the name of the range in a column and in the next could the page its on (all automatic page breaks) anyone have some code that can do this ??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using indirect to return a named range? | Excel Worksheet Functions | |||
| Query Named Range Return Single Column Value | Excel Worksheet Functions | |||
| Show only matches between a named cell range and the values in a page field - vba | Excel Programming | |||
| Return entries from one named range based on the contents of another | Excel Worksheet Functions | |||
| Search cells in a column and return yes/no if they are present in named range | Excel Programming | |||
Linear Mode
