On Apr 28, 6:00*pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
Range("W:W").SpecialCells(xlCellTypeFormulas, _
xlErrors).Offset(0, -22).Select

HTH,
Bernie
MS Excel MVP

wrote in message

...



Hi,

I have a piece of code that puts an error "NA()" in column W if the ID
in column A is not found on a reference worksheet ...

like this:
Range("W2:W" & Range("A1").End(xlDown).Row).Formula =
"=IF(COUNTIF(A:A,Recon_Activity!T:T)=0,NA(),"" "")"

Normally, say I want to select the entire row of all the ones with an
error put in by the formula, I can use this:

Range("A2:W" &
Range("A1").End(xlDown).Row).SpecialCells(xlCellTy peFormulas,
xlErrors).EntireRow.Select

or I can in one step delete them all.

However, I would like to select the cells in column A where an error
value is found in column W ... much the same as above, but I would
instead of selectiing the entire row, how do I try and select the
cells in column A where there is an error on the same row in column
W...

I tried the below but it doesn't work:

Range("A2:W" &
Range("A1").End(xlDown).Row).SpecialCells(xlCellTy peFormulas,
xlErrors).Rows(0,1).select

thanks for any help
Philip- Hide quoted text -

- Show quoted text -

Thanks - that's perfect !

Philip