vba filter dates

[Duncan_J]

Hi Folks,
I use to have this code but forgot it... I need to filter coulmn F less than
or equal to todays date, and greater than or equal to todays date minus 7
days. I had the code that would do that but alas it's gone...
Thanks for any help..

 

[Tom Ogilvy]

Turn on the macro recorder and perform the action manually. Use a custom
criteria and pick two dates (doesn't really make any difference which two).


Turn off the macro recorder

Now adjust the recorded code to apply the criteria you want.

 

[Duncan_J]

Hi Tom how are you doing?
Thanks for all the help in the past..
I'm just using =today() in the far right coulmn and beside that a coulmn
with =P2-F2 format the coulmn for numbers and filter less than or equal to
7... Works good enough...
Have a good weekend...
DJ

 

[Tom Ogilvy]

Can't beat that with a stick <g>