Pagebreaks vs page numbering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lupe - 22 May 2008 14:50 GMT

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.

Reply to this Message

Lupe - 22 May 2008 15:30 GMT

Hi,
I've tried out the macro from Ron de Bruin of "Create separate sheet for
each horizontal PageBreak" and I could use it, the only thing is that I would
like to have my first row which is header row also copied to the other
worksheets. Also the format of the columns (column width) is not copied.
Lupe

> Hi,
> I've used a macro of Steel Monkey on Page Breaks based on cell data and it
[quoted text clipped - 4 lines]
> not find exactly what I needed, I also checked Ron de Bruins site.
> Any help is appreciated.

Reply to this Message