find question
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 |
find question
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 |
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 |
find question
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 |
All times are GMT +1. The time now is 12:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com