Question about my code for vba autofilter

[dimitrisko]

Sub Anazitisi_apodosi()


Sheets("ÐÑÏÃÑÁÌÌÁ").Range("AB15:AB1000").AutoFilter , Field:=28, Criteria1:=">Sheet2.Range('A7').Value", Operator:=xlAnd, Criteria2:=<sheet2.range('b7').value"

End Sub

I want to autofilter within a range of numbers that are stored in two cells. I Dont want to be always the same numbers that i write in vba. Is that possible?</sheet2.range('b7').value"

 

[Fluff]

Try

Sheets("ÐÑÏÃÑÁÌÌÁ").Range("AB15:AB1000").AutoFilter , Field:=28, Criteria1:=">" & Sheet2.Range("A7").Value, Operator:=xlAnd, Criteria2:="<" & Sheet2.Range("b7").Value

 

[dimitrisko]

Thanks that seems to work when i check the filter but now the problem is that the list dissapear. not showing the data

 

[Fluff]

Try

Sheets("ÐÑÏÃÑÁÌÌÁ").Range("AB15:AB1000").AutoFilter Field:=1, Criteria1:=">" & Sheet2.Range("A7").Value, Operator:=xlAnd, Criteria2:="<" & Sheet2.Range("b7").Value

 

[dimitrisko]

Again not showing. But when i go manual after i run vba and check the filter i press ok and show the list. Should i put something else in the code to execute?

 

[Fluff]

That line of code is all you need.
Are your numbers real numbers or are they text?

 

[Fluff]

Cross posted https://www.excelforum.com/excel-pr...uestion-about-my-code-for-vba-autofilter.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[dimitrisko]

Yeah sorry i didnt see the rule. I thought its different site. All are formatted as numbers I dont know what is the fault

 

[Fluff]

is your data in a table?

 

[dimitrisko]

no table. Is there any way to upload a samle?