Ignore 'If statement' if the condition equates to error - HELP!

[cejhoney]

I am running a macro which filters a column to show only records with "#N/A" (ie an error), and copies these to another worksheet.
As I am aiming for no errors, there will be occasions when there is no filtered data.

My problem is that, unless I use something like xlCellTypeVisible, when there is no data shown it still copies and pastes all the hidden records.
And if I do use it when no filtered data, I currently get an error "No cells were found"

I have tried many iterations of code correction and i think i'm currently blinded by staring at it so long!

My current if statement reads as follows:

Please Login or Register  to view this content.

I think I might need to use some sort of On Error Resume Next statement, but I have never used these before.
When I tried adding that before the If statement, it just ignored the criteria and tried copying hidden rows - the exact opposite of what I want.
I'd like something that said, if this condition = error, skip over entire if statement and carry on with rest of the sub.

Please can someone offer some help?!

[sktneer]

May be like this.......

Please Login or Register  to view this content.

[AB33]

On error resume next will not get rid of the error if there are no visible cells.
You need to change this line

Please Login or Register  to view this content.

[cejhoney]

Thanks sktneer - that seems to have worked.

Thanks also to AB33, though your suggestion won't work as if there are no cells to display, there is no value to the 'If' condition.

[sktneer]

You're welcome. Thanks for the feedback and rep.

[AB33]

The idea of setting in this way would be for the code to jump in to the end before the auto-filter is switched on/off line so that there is nothing to copy as there are none visible cells.