View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kerrjohn@rogers.com is offline
external usenet poster
 
Posts: 2
Default Resetting Page Number in Excell

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