advanced filter using VBA
 

Can anyone help with this query:

Using VBA I want to be able to enable the user to filter on a selecte
range of data using an advanced filter with * signs.
For example they might enter "*vba*" to find any rows containing "vb
macro" or "vba example" etc.

For your information, the range of data is A1:G600 where the filtere
column is D.

Many thanks for your help.

Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=27764

advanced filter using VBA
 

Hi
maybe Ron's addin is of interest for you
http://www.rondebruin.nl/easyfilter.htm

"scottwilsonx" wrote:


Can anyone help with this query:

Using VBA I want to be able to enable the user to filter on a selected
range of data using an advanced filter with * signs.
For example they might enter "*vba*" to find any rows containing "vba
macro" or "vba example" etc.

For your information, the range of data is A1:G600 where the filtered
column is D.

Many thanks for your help.

Scott.


--
scottwilsonx
------------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...o&userid=11128
View this thread: http://www.excelforum.com/showthread...hreadid=277649