Hi,
I'm trying to add to my code an autofiler with multiple criteria, the criteria is held in single cell. The criteria is made up of anything from 5 to 30 cells, then i have tried to concatentate these separated by commas, in speech marks, speech marks and commac etc, set them as an array the use that in my filter, but nothing seems to work.
Can anyone help how to do this?
Thanks in advance
Blunder
I'm trying to add to my code an autofiler with multiple criteria, the criteria is held in single cell. The criteria is made up of anything from 5 to 30 cells, then i have tried to concatentate these separated by commas, in speech marks, speech marks and commac etc, set them as an array the use that in my filter, but nothing seems to work.
Can anyone help how to do this?
Thanks in advance
Blunder