find question
i am looking to find all values 0 in the range rtype(1 column), they're not
sorted, and copy b through q of whatever row they're in. then i want to
paste them into another workbook. it was just an exercise to see what would
happen, or if i could actually do it.
i already have it working with a for each cell loop, just trying another
approach.
thanks
--
Gary
"JS2004R6" wrote in message
...
Hi Gary,
A couple questions for you:
1) Are you looking to return (find) the first value that is 0 within the
range?
2) What if there is more than one value that is 0?
3) Is the range of values sorted?
Thanks,
James
"Gary Keramidas" wrote:
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
|