How to skip filter action if particular value is not found in record

Hi All,

I am preparing new macro for my report. Need your help. In column B I put filter on 1000 to 9999 and categories are updated in column D as Tax. So on there are few more categories. Right now the problem I am facing is - I want to put coding to skip this action if someday there are no rows with between 1000 to 9999. Macro should skip this action and should go for next action.

Below the coding for your reference. Thank you in advance.

Please Login or Register  to view this content.

Moderator's Edit: Use code tags when you post code. To do so, select the code and click on the # icon above.