Hi
I'm new to macros & vba, I have recorded a macro which will print off a selected area but the problem I'm have is how to change the date as I cannot get the macro recorder to ask for the user to enter the date.
Can anyone help me please.
Below is the macro. The date needs to be entered after this screen Sheets("Days Daily Sheet").Select
Sub OutloadingDays()
'
' OutloadingDays Macro
'
'
Sheets("Days Daily Sheet").Select
ActiveSheet.Range("$B$4:$D$86").AutoFilter Field:=3, Criteria1:="DL"
ActiveWindow.SelectedSheets.PrintPreview
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Sheets("Macro's").Select
End Sub
Thanks
Yogin
I'm new to macros & vba, I have recorded a macro which will print off a selected area but the problem I'm have is how to change the date as I cannot get the macro recorder to ask for the user to enter the date.
Can anyone help me please.
Below is the macro. The date needs to be entered after this screen Sheets("Days Daily Sheet").Select
Sub OutloadingDays()
'
' OutloadingDays Macro
'
'
Sheets("Days Daily Sheet").Select
ActiveSheet.Range("$B$4:$D$86").AutoFilter Field:=3, Criteria1:="DL"
ActiveWindow.SelectedSheets.PrintPreview
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Sheets("Macro's").Select
End Sub
Thanks
Yogin