AdvancedFilter in VB

Hi

I am using 2003 and have AdvancedFilter within a macro.

I want to change the critera to be the contents of a variable, not a specific cell

Does anyone know if this is possable - I have tried all the ideas I have!

Thanks

advanced filter only works with cell criteria.

--
Regards,
Tom Ogilvy

"loopy" <[email protected]> wrote in
message news:[email protected]...
>
> Hi
>
> I am using 2003 and have AdvancedFilter within a macro.
>
> I want to change the critera to be the contents of a variable, not a
> specific cell
>
> Does anyone know if this is possable - I have tried all the ideas I
> have!
>
> Thanks
>
>
> --
> loopy
> ------------------------------------------------------------------------
> loopy's Profile:
http://www.excelforum.com/member.php...fo&userid=9086
> View this thread: http://www.excelforum.com/showthread...hreadid=381212
>