View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Wild Bill[_2_] Wild Bill[_2_] is offline
external usenet poster
 
Posts: 90
Default Page Break Preview Page Number

Furthermore, .hpagebreaks.count will include "unused" hard page breaks
when print to fit is used (set by code or File /page setup/scaling. If
print to fit is used, and if any hard breaks exist, the relationship of
..hpagebreaks.count to actual page count would not be reliable. (So here
the hard break wouldn't even have to be at the edge of the print range.)

If any of this can matter to you, you might rethink Get.Document or
other suggestions from Jim or Tom or another that knows what the heck
they're doing :-O