Macro or VB to apply filter in spreadsheet

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.
 
B

Bob Phillips

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)
 
R

Roger Whitehead

Have you tried the macro recorder? Then reference the code in the ViewCode
right-click option of your button.
 
Top