Thread: Pages
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Pages

will this work?

Sub countpb()
MsgBox ActiveSheet.HPageBreaks.Count
End Sub

"Dominic Robinson" wrote in message
...
Is there any property of the worksheet or workbook object
that will tell me the number of pages that will be
printed?