Forum Discussion
Excel header/page #
I have a single worksheet that I need to print 150 pages of with sequential numbering pages in the header. For example: Truckload #1 - first page Truckload #2 - 2nd page etc. I cannot figure...
If you feel adventurous:
- Press Alt+F11 to activate the Visual Basic Editor.
- Select Insert > Module.
- Copy/Paste the code from my previous reply into the new window.
- If you want the "Truckload #nn" text in another cell than A1, change A1 in the code to the cell you want.
- With the insertion point anywhere in the code, press F5 to run the macro.
- Switch back to Excel.
- If you want to keep the macro, so that you can run it again later, save the workbook as a macro-enabled workbook (*.xlsm).
I figured it out. I had that sheet in a workbook with other tabs. Moved it to its own workbook. Printed fine!! Thank you so much!!