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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac