VBA in excel. Which code to use

  Desert Andy 16:26 19 Jan 15

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…