Hi bob,

Thanks for the reply. I just had a bit of a thickie moment - i hadn't
come back to the program for a few days and was working on the wrong
cell that was referenced in the macro. I did check the macro but with
my eyesight z and x looked very similar on the worksheet at 50%. oops.

Thanks all the same - with regards to the question i used wildcards to
find anything missing*

=COUNTIF(V2:W268,"missing*")

To anyone unfamilar this counts all cells within the range that have
"missing" written in the text. e.g missing stock, missing firm name,
missing etc etc etc.

Cheers, chris


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=490689