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
>
>
>