Auto filter by (ALL) custom from other sheet.

N

nader

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Aouto filter by macro 13
Dealing with the error: unable to filter on excel hc home school 0
Help me4 2
filtering (all) by value 0
Multiple inputs from "Input Box" 3
Copy filtered data to sheet 2 1
How to Activate Filter in Protected Sheet 2
Custom filter 26

Top