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]

You can't upload a file to the site, but you can upload to a share site such as OneDrive, DropBox & then post a link here

 

[dimitrisko]

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

 

[Fluff]

Thanks for the file.
The problem is that the numbers are not numbers.

 

[dimitrisko]

But i format as numbers and put comma. How to fix this?

 

[Fluff]

First off, in a blank cell enter this formula
=ISNUMBER(H16)
What does it say? then change the formula to look at A7 & what does that say?

 

[dimitrisko]

It say true to my normal file.

 

[Fluff]

Is that for both H16 & A7 ?

 

[dimitrisko]

https://drive.google.com/open?id=1c5OqCdTbrYwsHdY1z-I8PCedYvAudlBL
here is a sample from original file. Its module 8 name anazitisi_apodoseon

 

[Fluff]

That file works for me once you have corrected the sheet name & removed the , from in front of Field

 

[dimitrisko]

Sub Anazitisi_apodosi()
Sheets("ÐÑÏÃÑÁÌÌÁ").AutoFilterMode = False
Sheets("ÐÑÏÃÑÁÌÌÁ").Range("AB14:ab150").AutoFilter field:=1, Criteria1:=">=" & Sheets("ÐÑÏÃÑÁÌÌÁ").Range("A7").Value, Operator:=xlAnd, Criteria2:="<=" & Sheets("ÐÑÏÃÑÁÌÌÁ").Range("b7").Value
End Sub

So i rewrite the code like this. Again same problem. I removed , infront of field and same again
https://drive.google.com/open?id=1KEDFJ0sfU5aiV-SATL2SCFQuIIXonEdm