View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lupe Lupe is offline
external usenet poster
 
Posts: 30
Default Pagebreaks vs page numbering

Hi,
I've used a macro of Steel Monkey on Page Breaks based on cell data and it
gave me the result I wanted. But now I want the page number also to change
depending on the page breaks. At the moment I have a worksheet with many 126
pages and it gives as page number 1 of 126, 2 of 126, etc. But I want it to
start renumbering with every change in cell. I have checked postings but did
not find exactly what I needed, I also checked Ron de Bruins site.
Any help is appreciated.