Thread: Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Excel

How about using a little macro:

Option Explicit
Sub testme()

Dim iCtr As Long

For iCtr = 23 To 38 'whatever you want
With Worksheets("sheet1")
.Range("a1").Value = iCtr
.PrintOut preview:=True
End With
Next iCtr

End Sub

I printed from 23 to 38. Change it to what you need.
I printed Sheet1. Change that, too.
I put the number in A1. Use what you want.
and delete preview:=true when you're done testing.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Greeneyez2 wrote:

I have a Purchase Order template that I have to print, then renumber then
print again continuously. Is there a formula that make the template
automatically number sequentially even thought there is only one sheet?


--

Dave Peterson