advanced filter using VBA

  • Thread starter Thread starter scottwilsonx
  • Start date Start date
S

scottwilsonx

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced filter on last months results 6
Convert Advanced filter macro to VBA 2
****** Advance filter + Colouring using VBA ****** HELP!!!!! 3
Macro to copy value in field and insert it into filter 2
advanced filter office 2007 1
Pivot table macro filter data between yesterday and today (date+time) 0
Advanced Filter to Dynamic Range 5
OFFSET LOOKUP function in VBA? 9

Back
Top