VBA in excel. Which code to use

  Desert Andy 16:26 19 Jan 2015

Hi I have a cell value of #VALUE!, ie an error.

I want to write some code which looks through values, if it comes across this value, it changes the cell value to say "NO".

What code should I use please.

Many thanks for your help.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

InVision Studio takes on Adobe XD and Sketch

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?