date question

[Sherm01]

I currently have a macro that selects data based on the current date:
If ActiveCell.Value = Date Then

I need to change that to select the data in that cell that is equal to not only todays date but every date for 1 week in the future.
Ostensibly, it would be If ActiveCell.Value = DATE + 1 week.

 

[Tetra201]

Maybe

 If (ActiveCell.Value >= Date) And (ActiveCell.Value <= Date + 6) Then  ...

 

[Sherm01]

I will give it a try.... Thanks

 

[Sherm01]

Yep, that works

 

[Tetra201]

Glad to have helped.