printing consecutive weekdays/dates

B

bpreilly

New Member
Joined
Sep 25, 2008
Messages
1
I want to print consecutive weekdays and dates on multiple copies of the same worksheet is there any way to program this into a cell or preferably a header or footer

copy 1 "Monday May 1st"
copy 2 "Tuesday May 2nd"

and so on

Thank you in advance
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
Hello and welcome to MrExcel.

This macro will print out the selected sheet with the dates held in column A of the sheet "Dates" formatted in the centre footer.

Code: 
Sub PrintDates()
Dim lastrow As Integer, i As Integer, bResponse As Boolean
lastrow = Sheets("Dates").Cells(Rows.Count, 1).End(xlUp).Row
If lastrow < 1 Then
    MsgBox "Date list missing"
    Exit Sub
End If
For i = 1 To lastrow
    ActiveSheet.PageSetup.CenterFooter = Format(Sheets("Dates").Cells(i, 1).Value, "dddd dd mmmm yyyy")
    ActiveSheet.PrintOut
Next i
ActiveSheet.PageSetup.CenterFooter = ""
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Finding consecutive date pattern
Replies
8
Views
447
KRice
K
B
  • Question
Complex “consecutive weekday” formula
Replies
3
Views
264
awoohaw
awoohaw
J
  • Question
Formula for weekdays of date in another cell
Replies
4
Views
446
Jaxi
J
itsgrady
  • Solved
Return weekday only for a given month
Replies
3
Views
285
Fluff
Fluff
A
  • Question
Changing date on vba code.
Replies
3
Views
283
MARK858
MARK858

Forum statistics

Threads
1,214,661
Messages
6,120,790
Members
448,994
Latest member
rohitsomani

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top