Macro or VB to apply filter in spreadsheet

  • Thread starter Thread starter Stevie
  • Start date Start date
S

Stevie

Hi guys, I'm a novice excel user, but have the following
query in Excel 2000.

I have a spreadsheet that contains numerous rows and on
each row I have applied an auto filter.

I have a button that I want to attach a macro that will
automatically apply a filter to the data. Does anyone
have any ideas?

Many thanks.
 
Stevie,

Use record macro to get a macro that does it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Have you tried the macro recorder? Then reference the code in the ViewCode
right-click option of your button.
 
Back
Top