View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cheekyaardvark Cheekyaardvark is offline
external usenet poster
 
Posts: 10
Default Macro to Filter on active cell within autofilter

I have a spreadsheet that I already have autofilter activated on, what
I would like to do is have a macro that I can pop on my toolbar that
will filter the file based on the active cell contents, I had a macro
that did this in previous verison of excel but I somehow lost it during
migration to excel 2003 & cannot recreate it


Can anybody guide me on this

Appreciate it

Robin