Is there a way to count the number of page that's going to be print in a certain workbook?
I'm looking for a simple one, I know that I can do it with hbreak and vbreak.

Hi goLynxgo

Sub countpagebreaks()
    Dim myVPages As Integer
    Dim myHPages As Integer

        myVPages = ActiveWindow.SelectedSheets.VPageBreaks.Count + 1
        myHPages = ActiveWindow.SelectedSheets.HPageBreaks.Count + 1

        MsgBox (myVPages * myHPages)
End Sub

cheers

Matthew

That's the way I knew, the problem is that my macro prints hundreds of page and doing this thing makes the macro take 3 times more time to run

I only wanted to know if there were alternative ways to do it.
Thanks :)

How have you got the macro to select and print each page, are you using loops that select each page independently?

Cheers

Matthew