Add additional filter criteria depending on cell value

[dancing-shadow]

Hi,

Seems like an easy issue, but I can't seem to find the right code to do what I'm after.

I have code that applies an auto filter to a certain column. What I want to do is apply an additional filter to a second column dependent on a cell value on another sheet.

The code below comes up with the following error:
Run-Time error '-2147417848 (80010108)'
Automation error
The object invoked has disconnected from its clients

I'm assuming this is because I'm trying to run an 'If' statement from within a 'With' statement. I've tried re-selecting/defining the sheet and range, but still no luck Can someone point me in the right direction please?

Please Login or Register  to view this content.

[dancing-shadow]

No matter - found I'd not defined my Mnth variable properly!