add sequential # to each copy of excel page printed
In excel I have a form that I am printing 50 copies of. I would like to number each copy. Is there a formula that I can insert into one of the cells to calculate a page #? Or, any other suggestions on how to accomplish this? Thanks.
Anwsers to the Problem add sequential # to each copy of excel page printed
Try this macro. If you enter 0 or just press [Enter] at the prompt, no copies will be printed.
Dim CopiesToPrint As Integer
Dim CopyNumber As Integer
CopiesToPrint = Application.InputBox("Enter # of copies to print:", "Copies", 0, , , , , 1)
If CopiesToPrint = 0 Then
'these refer to the sheet/form you are going to print
'and to the cell you want to put the copy # information into
For CopyNumber = 1 To CopiesToPrint
'put the phrase "Copy # of ##" into cell R20 of Sheet1
' the # will increment, the ## will be the # of copies you requested.
Worksheets("Sheet1").Range("R20") = "Copy " & CopyNumber & " of " & CopiesToPrint
Worksheets("Sheet1").PrintOut copies:=1 ' do them 1 at a time
To put the code into the workbook for use: open the workbook and press [Alt]+[F11] to get into the Visual Basic Editor. In the VBE, use Insert --> Module from its menu bar and copy the code above and paste it into the empty code module presented to you.
Edit the "Sheet1" entries in it to hold the actual name of your worksheet with the form on it (include the quotation marks at each end of its name). Change the "R20" to the cell address where you want the copy number shown, and modify the
= "Copy " & CopyNumber & " of " & CopiesToPrint
to put what you want into that cell. If you just wanted the copy number then it would read:
Worksheets("Sheet1").Range("R20") = CopyNumber
Close the VBEditor and run the macro from the [Developer] or (I think it is 2007 on the) [View] tab Macros selector.
Hope this helps.
Because of this add sequential # to each copy of excel page printed error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.
Lastly, this error add sequential # to each copy of excel page printed can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.
In order to resolve add sequential # to each copy of excel page printed error or repair the corrupted and damaged Windows files, you will need a add sequential # to each copy of excel page printed error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:
- Start the computer and log in as administrator
- Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
- Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
- On the new confirmation window that appears, click Next
- Restart your computer after the restoration has been completed
Another Safe way to Repair the Problem: add sequential # to each copy of excel page printed:
How to Fix add sequential # to each copy of excel page printed with SmartPCFixer?
1. Download Error Fixer. Install it on your system.
2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.
3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: How to Resolve - Adobe CS 5.5 Master's Collection Install Failure error 1935.?,After I shut down my computer running Windowa 7, it re-starts on it'e own a short time later [Anwsered],How Can You Fix - Add-ons became incompatible?,[Anwsered] adobe flash keeps sending update notices. i did 3 days ago.,Solution to Problem: add-on incompatibile,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded