Worksheet Macro to add page numbers

**ChemistB** · 08-29-2008, 04:11 PM

I tried to modify Martin's macro code here (http://www.excelforum.com/excel-misc...ge-titles.html) to work as a BeforePrint event but it doesn't work.
Here's my code.

Please Login or Register  to view this content.

Without the "Cancel = True line, it prints twice but always with a 2 in the first line (it's a 2 page document). With the Cancel = True line, it doesn't print at all. Thoughts?

ChemistB

**shg** · 08-29-2008, 04:25 PM

Step through the code and what happens?

Specifically, what is the value of TotalPages?

**ChemistB** · 08-29-2008, 04:36 PM

Which brings me to a question I've been wanting to ask.

I can only step through (F8) code in a module. When I try it in a worksheet or Thisworkbook, nothing happens. How do I step through code in thisworkbook? Excel 2000

ChemistB

**VBA Noob** · 08-29-2008, 04:59 PM

Play with it in a normal module.

Not sure what your after as you don't actual say (least I don't think so).
If you want to print 3 pages and have the cell value hold the page number you could try

Please Login or Register  to view this content.

Maybe some useful links for others
http://www.ozgrid.com/Excel/excel-page-breaks.htm
http://www.rondebruin.nl/print.htm#not

VBA Noob

**royUK** · 08-29-2008, 05:00 PM

hi ChemistB

I never use Excel4 macros, use the hPagebreak

Please Login or Register  to view this content.

**shg** · 08-30-2008, 11:38 AM

Originally Posted by Chemist

How do I step through code in thisworkbook?

There or anyplace else, put the cursor in an executable line of code (i.e., not, e.g, a Dim statement), and hit F9 to add a breakpoint. Then trigger the code in the normal fashion, and step through the code after it breaks.