| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro turn off AutoFilter
A while back, Bernie Deitrick posted the following code:
On Error Resume Next Columns("D:D").AutoFilter Field:=1, Criteria1:="DONCASTER" Range("D2:D65536").SpecialCells(xlCellTypeVisible) .EntireRow.Delete Repeat the two lines above for each condition, then use the line Columns("D:D").AutoFilter Field:=1 to turn off the filter, and your macro is done. I'm using column A and different criteria, and it works except that I'm still seeing a drop-down arrow in cell A1. How do I remove the drop-down arrow? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro turn off AutoFilter
Activesheet.autofiltermode = false
Should remove all the arrows. Erin wrote: A while back, Bernie Deitrick posted the following code: On Error Resume Next Columns("D:D").AutoFilter Field:=1, Criteria1:="DONCASTER" Range("D2:D65536").SpecialCells(xlCellTypeVisible) .EntireRow.Delete Repeat the two lines above for each condition, then use the line Columns("D:D").AutoFilter Field:=1 to turn off the filter, and your macro is done. I'm using column A and different criteria, and it works except that I'm still seeing a drop-down arrow in cell A1. How do I remove the drop-down arrow? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro turn off AutoFilter
You are wonderful! That did the trick -- thanks!
"Dave Peterson" wrote: Activesheet.autofiltermode = false Should remove all the arrows. Erin wrote: A while back, Bernie Deitrick posted the following code: On Error Resume Next Columns("D:D").AutoFilter Field:=1, Criteria1:="DONCASTER" Range("D2:D65536").SpecialCells(xlCellTypeVisible) .EntireRow.Delete Repeat the two lines above for each condition, then use the line Columns("D:D").AutoFilter Field:=1 to turn off the filter, and your macro is done. I'm using column A and different criteria, and it works except that I'm still seeing a drop-down arrow in cell A1. How do I remove the drop-down arrow? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| turn macro into add-in | Excel Discussion (Misc queries) | |||
| Macro to turn on/off rowliner? | Excel Discussion (Misc queries) | |||
| How to do a macro for IF cell b1 is < b3 turn b1 red? | Excel Discussion (Misc queries) | |||
| Excel 2003 - turn off option in autofilter | Excel Discussion (Misc queries) | |||
| Turn off warnings in Macro | Excel Worksheet Functions | |||
Linear Mode
