Thanks - That is excellent

The only issue I have is with Dates. What format should the source cell
be so that the autofilter recognises it as a date.

I can copy and paste this info into the auto filter box manually and it
works, but when the Macro runs it cannot find the data that is in the
cell.

This is the finishing touch of a long piece I have been working on and
hope someone can help

Thanks


--
DB100
------------------------------------------------------------------------
DB100's Profile: http://www.excelforum.com/member.php...fo&userid=9176
View this thread: http://www.excelforum.com/showthread...hreadid=268145

Try converting the date to a long integer or double and supply that as the
argument for the auto filter.

On Tue, 12 Oct 2004 08:59:07 -0500, DB100
wrote:


Thanks - That is excellent

The only issue I have is with Dates. What format should the source cell
be so that the autofilter recognises it as a date.

I can copy and paste this info into the auto filter box manually and it
works, but when the Macro runs it cannot find the data that is in the
cell.

This is the finishing touch of a long piece I have been working on and
hope someone can help

Thanks