return what page a named range is on

C

Chris Salcedo

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 ???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
no page break in named range 2
Search an array of sheets for an array of numbers & return count of numbers 11
Add sheet and name it unless it already exists 12
Search other sheets for numbers & color them 10
Array with many cells from a row but not in order or together 11
Sum work hours to hours & nearest 10th of an hour 14
Post my named ranges in column A 10

Top