Forum

Select Worksheet Ce...
 
Notifications
Clear all

Select Worksheet Cell for Print Macro

2 Posts
2 Users
0 Reactions
162 Views
(@paul-sanft)
Posts: 35
Trusted Member
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
(@debaser)
Posts: 836
Member Moderator
 

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
Share: