Thread: turn an filter off or back to All
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ADG ADG is offline
external usenet poster
  
Posts: 76
Default 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 With QuoteReply With Quote