| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
turn an filter off or back to All
I'm using the GetObject() function to get information from another workbook.
I have a field, Include/Exclude, that has the criteria1 set to =Include. How can I change this to All or turn the filter off? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
turn an filter off or back to All
Hi
Use the ShowAllData method to show all rows Worksheets("Sheet1").ShowAllData To remove the arrows use the below Worksheets("Sheet1").AutoFilterMode =False -- Tony Green "Dennis" wrote: I'm using the GetObject() function to get information from another workbook. I have a field, Include/Exclude, that has the criteria1 set to =Include. How can I change this to All or turn the filter off? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, UNDO/REDO is grayed out. How can I turn it back on? | Excel Discussion (Misc queries) | |||
| How do i turn the merge cell option back on? | Excel Discussion (Misc queries) | |||
| How can I turn back on my sort options in excel 2007? | Excel Worksheet Functions | |||
| How can I turn back on the sort button in excel 2007? | Excel Discussion (Misc queries) | |||
| How do I turn 'update links' back on when turned off? | Excel Worksheet Functions | |||
Linear Mode
