I need result this: in macro excel
- Code: Select all
Range.AutoFilter Field:=2 (criteria1 > 10 And criteria2 < 15) Or (Cretiria3 > 20 And criteria 4 < 25)
thank you
New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
Need Help
6 posts
• Page 1 of 1
Re: Need Help
by pecoflyer » Fri Nov 27, 2015 10:00 am
Hi and welcome
in the future please wrap code with code tags. I will do it for you this time.
in the future please wrap code with code tags. I will do it for you this time.
- 0
A relevant topic title helps get faster and more answers
- pecoflyer
- Moderator
- Posts: 1274
- Joined: Jan 24, 2012
- Location: Belgium
- Reputation: 39
- Excel Version: 2003/2007/2010
Re: Need Help
by pecoflyer » Fri Nov 27, 2015 11:56 am
First let me emphasize that, as far as I know, we are not related.
Second as Moderator on this forum I have to see that things are kept orderly so that an optimal use can be done of the forum
Third,I only provide answers where I can help, which is not the case in VBA
Second as Moderator on this forum I have to see that things are kept orderly so that an optimal use can be done of the forum
Third,I only provide answers where I can help, which is not the case in VBA
- 0
A relevant topic title helps get faster and more answers
- pecoflyer
- Moderator
- Posts: 1274
- Joined: Jan 24, 2012
- Location: Belgium
- Reputation: 39
- Excel Version: 2003/2007/2010
Re: Need Help
by NoSparks » Fri Nov 27, 2015 12:47 pm
As far as I know there is a 2 criteria limit per column with autofilter when the criteria is calculated like that.
- 1
- NoSparks
- Excel Hobbyist
- Posts: 637
- Joined: May 28, 2014
- Reputation: 103
- Excel Version: 2010
6 posts
• Page 1 of 1
Return to Macros and VBA Questions
Who is online
Users browsing this forum: Google [Bot] and 54 guests