View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Salcedo Chris  Salcedo is offline
external usenet poster
 
Posts: 25
Default 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 ???