find question
 

forgot the set

set rngFound = Cells.Find(What:="Your_Text", LookIn:=xlValues)

and instead of cells, i would use Range(rType)


--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message news:...
what would you use in place of this to find a value in a range that's 0

rngFound =Cells.Find(What:="Your_Text", LookIn:=xlValues)

--


Gary