Use DataFilterAutoFilter. On the Date column, in the dropdown box,
select Custom. Use the parameter of "Greater than or equal to" and
choose your beginning date from the dropdown. Select "And" and use
"Less than or equal to" and choose your ending date from the list.
Click OK

Only the rows that meet your criteria will be displayed.

Does this work for you?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=398322