VBA Compile Error: Constant required

[plunder]

Hi

I'm new to VBA and was trying to make a code that allows me to add a day to the date each time the sheet gets printed.

Sub DATE_PRINT()

Const copies_to_print = 'enter the number of copies here
Dim begin_date As Date
Dim n As Integer

begin_date = 'enter the beginning date here

For n = 1 To copies_to_print Step 1

ThisWorkbook.Sheets("Sheet1").Range("A1").Value = begin_date
ThisWorkbook.Sheets("Sheet1").PrintOut COPIES:=1

begin_date = begin_date + 1
Next

End Sub

This is my code but it keeps saying constant required and Im unsure what to do. Any help would be appreciated

[Marc L]

Hi,

just obviously fill the constant with a value like you can see in VBA help …

[ByteMarks]

It's because there is no value assigned to the constant after the = sign.


Maybe it would be useful to get the number of copies and the date each time?

Please Login or Register  to view this content.

[plunder]

That works perfectly thank you so much!