Microsoft Office Forums

Microsoft Office Forums (https://www.msofficeforums.com/)
-   Excel Programming (https://www.msofficeforums.com/excel-programming/)
-   -   New number after every print (https://www.msofficeforums.com/excel-programming/28950-new-number-after-every-print.html)

paltser 12-02-2015 02:58 AM

New number after every print
 
Hey

I am trying to make macro wicth chanse number after every printed page.
In must to be able to start how many copys i want and starting number.

Code:

Sub PrintCopies_ActiveSheet()

 Dim CopiesCount As Long
 Dim copynumber As Long
 Dim algusnumber As Long

 CopiesCount = Application.InputBox("How many copies do you want?", Type:=1)
 algusnumber = Application.InputBox("First number", Type:=1)

 For copynumber = algusnumber To CopiesCount
 With ActiveSheet
    .Range("B1").Value = copynumber
    .PrintOut
 End With
 Next copynumber
 End Sub


that dosnˇt work...:S


All times are GMT -7. The time now is 04:06 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft