| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any way to apply a filter automatically after changing a cell? | Excel Discussion (Misc queries) | |||
| keep total formulas / rows when apply filter | Excel Discussion (Misc queries) | |||
| how to apply filter based on list or combo box?? | Excel Discussion (Misc queries) | |||
| Can you apply the auto filter to data that are filtered? | Excel Worksheet Functions | |||
| Program to apply macro to new spreadsheet | Excel Discussion (Misc queries) | |||
![Stevie[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
