problem autofiltering text (numbers) including comma

[petca059]

Hi!
Im writing a program that lets the user choose filtercriterias from comboboxes and checkboxes.

two programs containing the "exact" same code react differently. When filtering one sheet containing numbers and text formated to "text" The numbers get an error notation which says "number stored as text".

The other sheet, formated in the same way, doesnt have this notation by its cells.

The autofilter on the first sheet works fine! ex. finding all rows containing 7,23...
The second sheets filterfunction doesnt work.

Here's some of my code:

Please Login or Register  to view this content.

The data comming in to the autofilter seems on the "watch" to be correct.. a string with the value 7,32 for ex.

anyone whos got an idea what the problem could be? seems like something with the commas.

[snb]

Please Login or Register  to view this content.

[petca059]

Im sorry, can you please explain that code?

the replace"thing" solved it when i used it. Thanks! Would still like an explaination of the other things in your code didnt work for me..

[snb]

It's meant to be the replacement and improvement of your sub 'kontfilter'.

But it has an omission

Please Login or Register  to view this content.

[honoriatus]

Try this:

(...)
Selection.AutoFilter Field:=kol, Criteria1:="=" & filtervarde, VisibleDropdown:=False
(...)



~~~~> Criteria1:="=" & YourVariable

Hope it works