Vba if my filter returns no value

[Revathi kannan]

Hi all,

i have the below code wherein it will delete all data in column B except #N/A but sometimes my filter may not have any data except #N/A so i need skip on the next sub routine.

Can someone help me on this ? Where should I add those rules ?

Please Login or Register  to view this content.

[Mumps1]

It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.

[Revathi kannan]

Hi Mumps1,

I have attached my sample report wherein with the above code I will delete all the row except #N/A but I need to include the rule if my rule doesn't exists so that I should stop running the code.

Please assist.

[Fluff13]

How about

Please Login or Register  to view this content.