Skipping Blanks and Errors

[Sthlm]

I'm pretty new to VBA and I've run in to an issue that must be fairly simple to fix...

The code below is what I have and works fine ignoring empty cells in a range as long as there are no errors in my range. What I need is to add an option to not count errors also.

Please Login or Register  to view this content.

Any ideas? I've tried a few options with ElseIf and Or Not Iserror(Cell) but I haven't got it to work.

Thanks!

[Kaper]

Hi,

Have you tried just:

Please Login or Register  to view this content.

[Kaper]

PS. As of OR you mentioned - here it shall be AND rather than OR, so:

Please Login or Register  to view this content.

[Sthlm]

Thanks that did the trick!

[Kaper]

Glad to see it worked, and thanks for marking thread solved and for added reputation