First Page Number VBA

[ZachA3]

Is there a VBA that will grab the value in cell A2 and make that the first page number? I need this for about 10 different sheets in a workbook.

Thanks!

Zach

[JOHN H. DAVIS]

Not clear what you're after, but this will name the activesheet the Range("A2") VALUE

Please Login or Register  to view this content.

[ZachA3]

Sorry, that was vague. I have page numbers in the footer. I would like the first number to be a VBA code based on the value of the sheet in cell A2.

Hope that clears it up.

Thanks!

Zach

[JOHN H. DAVIS]

Maybe?

Please Login or Register  to view this content.

[ZachA3]

The problem is that will make all the page numbers the same value. For example, I put in 2 and all three pages have 2. They should be 2, 3, 4.

[Solus Rankin]

Are you talking about multiple pages within a sheet? or multiple sheets?

[ZachA3]

Both. I have 10 or so sheets, each contain between one to 10 pages. The number of pages will be dynamic, depending on when I run the model. I have VBA that will total the breaks, thus if sheet 2 has 4 pages then I would like sheet 5 to start at page 6.