Name as the First Row of the page

[Chandresh]

Hi ,

I have multiple pages in a sheet I am trying to give first row of the cell as a file name reference with the below code but its not working
can any one help me the correct code

Example first row of my page 1 is " ABS" my file name will be "ABS" my 2nd page first row is "ZYZ" my file name should be "ZYZ"

Code:
Set fileNameCell = fileNameCell.Offset(.HPageBreaks(page).Location.Row-1)