[RESOLVED] Excel filtering problems galore!!

[direktoren]

Hi

I am trying to get an autofilter to sort a datasheet using a combox to set the criteria. is this possible??

I've tried the following:

If Not ComboBox2.Value = "" Then
Selection.AutoFilter field:=2, criteria:=ComboBox2.Value

But I get an error on that one (I've also tried different variations of the above) - is it possible to define a criteria as a user chosen variable? and if not how can i get around it?

Nicolaj