Without recreating your scenario I'm not quite sure what you need. If you
want to refine the search range to cells with errors, change

..SpecialCells(xlCellTypeFormulas, 23) 'all formulas
to
..SpecialCells(xlCellTypeFormulas, 16) 'formula errors only

Or record a macro, press F5 Special cells and whatever is appropriate.

And/or also some a nested If's perhaps

If InStr(cell.Formula, "VLOOKUP") then
if IsError(cell) then
If ... then

Regards,
Peter

"solomon_monkey" wrote in message
oups.com...
Thanks Peter... however, being as the vlookup is in column B regarding
column A and looks in A & B every reference is a circular reference...
this is fine for what I want it to do to a point... but only matters
when a vlookup would otherwise return an #N/A... Sorry to be awkward...