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

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

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

i'm just going to forget about it, thanks for offering

--


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