There's an option on File|page setup|sheet tab.

I recorded a macro when I changed it to 1 and when I deleted everything in that
box:

The lines that were important we
ActiveSheet.PageSetup.FirstPageNumber = 1
and
ActiveSheet.PageSetup.FirstPageNumber = xlAutomatic

wrote:

Good Day
I am working on a large spreadsheet created elsewhere and I am trying
to add a macro to print a multipaged tab. When I insert the command
for page number [in VBA as well as manually], the first page of the
report starts with "Page 17 of ___".

I have no idea how it calculates the first page as #17, and I can't
find a way to get it to smarten up and count properly.

Does anyone know what is happening and what to do about it?

Many Thanks

John Kerr

--

Dave Peterson