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
|