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 :)


--
loopy
------------------------------------------------------------------------
loopy's Profile: http://www.excelforum.com/member.php...fo&userid=9086
View this thread: http://www.excelforum.com/showthread...hreadid=381212

AdvancedFilter in VB
 

advanced filter only works with cell criteria.

--
Regards,
Tom Ogilvy

"loopy" wrote in
message ...

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