View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default inserting page number in cell

You have to locate all the horizontal and vertical pagebreaks and compute
the numbering.

look at hpagebreaks and vpagebreaks collections.

--
Regards,
Tom Ogilvy

David White wrote in message
...
I need to be able to have automatic page numbers located
in a cell instead of locating it in the header or footer.
I have seen this done before but can not work out the
coding.

help please!

David