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

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