for some reason, the advance filter only works for one criterion...when i try to expand the range...it stops working...
e.g im only filtering for
OSP
397
if i add another column
OSP
400
the advanced filter via VBA stops working (just shows blank).....yes, I have modified the named range...