I need to print a single sheet 50 times but have it be numbered 1 of 50, 2 of 50 etc.

Try this:

Please Login or Register  to view this content.

I have assumed you want the 1 of 50 in cell A1. Change this if you want it someplace else. I also assumed your print range was A1 to J50. Change this also if it is different.

To install your code:

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button