Solved how to know pages number in a sheet?

July 4, 2016 at 19:13:00
Specs: Windows 7
I have a sheet that have some page, but i want to know pages number of sheet. How to know pages number in a sheet that not show in preview pane?

See More: how to know pages number in a sheet?

Reply ↓  Report •

July 4, 2016 at 20:43:07
Not sure this is what your looking for, but in Print Preview
Put your cursor on the bottom bar, (at the very bottom of screen)
Right Click,
and in the Popup Menu, select Page Number

You should then be able to scroll thru your sheet and the page number
will be displayed in the lower left, on the bottom bar.


Reply ↓  Report •

July 5, 2016 at 04:55:46
✔ Best Answer
The following code can be found at:

Sub HowManyPagesBreaks()
Dim iHpBreaks As Integer, iVBreaks As Integer
Dim iTotPages As Integer
    iHpBreaks = ActiveSheet.HPageBreaks.Count + 1
    iVBreaks = ActiveSheet.VPageBreaks.Count + 1
       iTotPages = iHpBreaks * iVBreaks
         MsgBox "This sheet will require " & iTotPages & _
                " page(s) to print", vbInformation, ""
End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Reply ↓  Report •

Related Solutions

Ask Question