AdvancedFilter criteria in code rather than range?

F

FlintstoneMan

New Member
Joined
May 12, 2011
Messages
7
Is it possible to put the criteria for advanced filter in the code rather than in a range in the worksheet?

Thanks.
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
No, it isn't, I'm afraid.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question Question
Filter using a cell value as the criteria
Replies
5
Views
152
Peter_SSs
Peter_SSs
Z
  • Solved
VBA: Advanced Filter Limitations
Replies
3
Views
787
zero269
Z
O
  • Solved
Most Consecutive appearances in a range
2 3
Replies
27
Views
339
Fluff
Fluff
S
  • Question Question
Help with VBA AdvancedFilter
Replies
3
Views
431
sidel801
S
T
  • Question Question
Multiple filters on filtered list
Replies
1
Views
611
Cubist
Cubist

Forum statistics

Threads
1,224,564
Messages
6,179,548
Members
452,927
Latest member
rows and columns

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top