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