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

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