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]

The sheet name in your macro does not match the sheet name on the tab. I don't know if that's just down to language packs or not. But try

Sheet2.AutoFilterMode = False
Sheet2.Range("AB14:AB200").AutoFilter field:=1, Criteria1:=">=" & Sheet2.Range("A7").Value, Operator:=xlAnd, Criteria2:="<=" & Sheet2.Range("b7").Value

 

[dimitrisko]

i can't get it to work...same problem. Is it running ok in your system?
https://drive.google.com/open?id=1OpqpQEIAVOWrYoAbqpHn_BDGtx7Vym5K

 

[Fluff]

It works fine for me.
Click the filter > Number filters
There should be a tick against "Between" click that & what does it show?

 

[dimitrisko]

https://drive.google.com/open?id=1tvlehUcGamjvczwmhdf4kZvFikbGOjub

It shows the correct range and when i press ok it apply the filter. The problem is that i want the macro to do it auto without doing me manual.

 

[Fluff]

In that case I've no idea.
I've never come across that sort of behaviour.

 

[dimitrisko]

Do you know what else could work in my case? any alternative? All macros in my workbook work perfect i dont know why this dont

 

[Fluff]

Fraid not. Your code should work.

 

[dimitrisko]

https://drive.google.com/open?id=1yFzYnJeZ7_nsxqJ5TFjca-izzmSMjJjD

Why in this workbook works perfect i cant understand?