Notifications
Clear all
Topic starter
Hi,
I have the attached macro which, when activated, prints the number of worksheets corresponding with the date range; it effectively prints every sheet with the sequential date. What I need it to do is select the dates that are entered in another worksheet to avoid having to touch the macro every time a date change is required.
Appreciate and ideas.
Paul
Posted : 26/01/2023 2:09 am
Instead of hardcoding them in the code, refer to ranges like this:
startDate = sheets("sheet name").range("A1").value
for example.
Posted : 26/01/2023 8:46 am