View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Printing consecutive dates

You could create a macro:

Option Explicit
Sub testme()
Dim iCtr As Long
Dim myDate As Date

myDate = Date ' or give it a starting date dateserial(2007,1,22)
With Worksheets("sheet1")
For iCtr = 1 To 5
.Range("a1").Value = myDate
.PrintOut preview:=True
myDate = myDate + 1
Next iCtr
End With
End Sub


This puts the date in A1 of Sheet1 and prints it 5 times.



Bradford88 wrote:

Is it possible to print consecutive dates on each new page printed? I made a
form for my business that I print out and write on manually, but I have to
fill in the new date everyday. I would like to print multiples of this form
with each new form printed to have a new date on it without having to print
them one page at a time.


--

Dave Peterson