Dealing with error when looping through a range

[Sean Thomas]

Hi,
Anyone got an idea how to overcome this problem.
if looping through a range, one of the cells has #N/A it causes a "Run Time Error 13 Type Mismatch error
usually the range will have numbers in them.
How do i get the loop to go to next cell?

Please Login or Register  to view this content.

[JosephP]

Please Login or Register  to view this content.

I reckon countif would be more efficient than looping though

[AB33]

You can include an error trapping
On error resume next

Or you could inlcude one of thes line in your code.

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[Sean Thomas]

Thanks all.
That done the trick.
Had amoment of blindness then.