Good Morning, i got the following code from Tom Ogilvy which works
really great & would like to know if one can use the same formula to
search for a number e.g. "0" or "1" ?

On Error Resume Next
set rng = columns(22).Specialcells(xlConstants,xlErrors)
On Error goto 0
If not rng is nothing then
Intersect(Range("V:AB"),rng.EntireRow).ClearContents
End If

Sorry for the ignorance, but i am fairly new to this game

Tempy

*** Sent via Developersdex http://www.developersdex.com ***