Question: I would like to find out the first row number of the page1. 

Using the following code can find the last row number of page 1.

```
ThisWorkbook.Worksheets("Sheet1").HPageBreaks(1).Location.Row - 1

```

But I have to find the first row number of Page1.

Would anyone has idea on it?

Thanks a lot

Answer: 
You can use SpecialCells to get the first visible row.

The below code will return back the address for the first visible row of the ActiveSheet

```
msgbox ActiveSheet.Cells.SpecialCells(xlCellTypeVisible).Rows(1).Address

```

or if you just want the row number

```
msgbox ActiveSheet.Cells.SpecialCells(xlCellTypeVisible).Rows(1).Row

```
This will get you the first row of the first page:

```
Sub dural()
    Dim nRow As Long, s As String
    Dim r As Range
    s = Sheets("Sheet1").PageSetup.PrintArea
    Set r = Range(s)
    nRow = r(1).Row
    MsgBox nRow
End Sub

```