Advanced filtering criteria fail when the number is not an integer!

Hi.

I need to use the advanced filter to copy cells into a different sheet. My code is this.

Please Login or Register  to view this content.

Problems:

1) For some reason Sheets("SR26").Range("A1").CurrentRegion.AdvancedFilter just doesnt work. I dont have any empty rows in that range(but there might be some empty cells, is there an alternative to this?)

2) When i put critiria like >10.1 or anything with a decimal (not integer) it returns nothing. I dont know why, and if that is , i dont know how to convert the ranges to smthg like double.

Is there another workaround?

Ty



[Edit] , I think that it does not recognize it as a number after i put the decimal. The code on the critiria is smthg like this

Please Login or Register  to view this content.

2nd SOLVED.

For some weird reason it needed for me to cast the 10,1 to 10.1 (the hint is in the decimal character from decimal to point. I did it with
First=mod(number;1) and Second=round(int(number);0)*1000 and then i set the critiria to ="<="&First&"."&Second

I still dont know why the first one is not working.