Name as the First Row of the page

Chandresh

Board Regular
Joined
Jul 21, 2009
Messages
101
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)
 

Forum statistics

Threads
1,082,612
Messages
5,366,610
Members
400,906
Latest member
incanus

Some videos you may like

This Week's Hot Topics

Top