View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Printing a number of pages with them numbered

So you do not really want x copies of the same sheet; you want to print it x
times with changes ?
Depending how/where you are numbering the tags, amend this:

Private Sub CommandButton1_Click()
Dim PrintCount As Long
Dim i As Long

Const NUMBERSONLY As Long = 1

PrintCount = Application.InputBox("How many tags ?", "Print count", , , , ,
, NUMBERSONLY)

For i = 1 To PrintCount
With Worksheets(1)
.Range("A1").Value = i
'.PrintOut
End With
Next

End Sub

NickHK

"mslabbe" wrote in message
...
Hi All!

I'm trying to come with a macro that will ask the user to select how many
copies of a sheet to print. The thing that are being printed are tags. I
would like to number themas the are printed.

Any suggestions?

Thanks in advance