Excel automated task Help

I have a sheet in Excel 2013, and use it for a daily schedule. To generate the sheet, I put a number (from 1 to 31) in cell C1, and all the cells in the sheet update automatically. I then print out the page and go to the next number (so first I enter 1, print, then 2, print, then 3, print, etc.)

I would like to automate this task, so that I can just click GO and excel will fill in the numbers 1 to 31 in the sheet, and print out the sheet (on the default printer) for each number.

Can someone help me create this automated task?
Lev SeltzerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Harry LeeConnect With a Mentor Commented:
WEBuilder,

Try this code.

Sub PrintDailyReport()
Dim I As Integer

For I = 1 To 31
    Range("C1").Value = I
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
        IgnorePrintAreas:=False
Next

End Sub

Open in new window

0
 
Rgonzo1971Commented:
Hi,

Could you send an example?

Regards
0
 
Lev SeltzerAuthor Commented:
Perfect. Thank you very much for your quick response!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.