Macro or VB to apply filter in spreadsheet
 

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.

Macro or VB to apply filter in spreadsheet
 

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)

"Stevie" wrote in message
...
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.

Macro or VB to apply filter in spreadsheet
 

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


--
HTH
Roger
Shaftesbury (UK)


"Stevie" wrote in message
...
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.