Thursday, March 31, 2016

Solution to Problem: add sequential # to each copy of excel page printed

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

Download SmartPCFixer for Free Now

Try this macro.  If you enter 0 or just press [Enter] at the prompt, no copies will be printed.
 
Sub PrintMultipleCopies()
  Dim CopiesToPrint As Integer
  Dim CopyNumber As Integer
 
  CopiesToPrint = Application.InputBox("Enter # of copies to print:", "Copies", 0, , , , , 1)
  If CopiesToPrint = 0 Then
    Exit Sub
  End If
 
  '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
  Next
 
End Sub
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:

  1. Start the computer and log in as administrator
  2. Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
  3. Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
  4. On the new confirmation window that appears, click Next
  5. 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.


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,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

No comments:

Post a Comment