Thread: Auto filter by (ALL) custom from other sheet.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nader Nader is offline
external usenet poster
  
Posts: 44
Default Auto filter by (ALL) custom from other sheet.
hi

I use following mocro:

Sheets("Sheet1").Select
Selection.AutoFilter Field:=6, _
Criteria1:="=" & Range("Sheet2!A1").Value

I need to filter(All) by putting a value in cell ("Sheet2!A1").

Thanks.

Reply With QuoteReply With Quote