Filtering in a macro
 

I have been searching the forums for a simple macro to filter data for
=now() s date. I tried to use the macro recorder but it wont let me
use filters. I would imagine that its very simple to do but cant
figure it out.

Obviously I would like to revert back to the original once its filtered
and the data is used. I have the middle part of the macro working so I
just need to know how to filter and reset it back.

Thanks for your help,
Ken


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=377828