View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 271
Default Can a Macro utilize an auto filter?

I have column in my spreadsheet and it already has an autofilter associted
with it. I use the custom auto filter function to do a "contains" search for
a particualar string I am looking for. I was wondering if I could create a
macro that is associated to a button that does the same thing? I want an
un-experienced user to be able to type the string they are looking for into a
text box, click the button, and all the fields in that column that contain
the string will appear. Is this possible?