snowdyce
06-25-2013, 10:58 AM
Hey Experts,
I have run into a speed bump on some VBA code, which I think there is a simple solution I cannot find. I have a list of variables (1 thru 7). I want to check a range(Column) to see if a value of "1" is in that range. I do not need to save the value or care if it repeats, just if it appears at least once. I tried using a For formula that checked each Row, but it repeated each time it found a 1 in the range. I just want it to stop the search if it finds it, and then do action A if it does or aciton B if it doesnt. I also played with Find in ranges and I could not get it to work, andy ideas? Thanks. :banghead:
I have run into a speed bump on some VBA code, which I think there is a simple solution I cannot find. I have a list of variables (1 thru 7). I want to check a range(Column) to see if a value of "1" is in that range. I do not need to save the value or care if it repeats, just if it appears at least once. I tried using a For formula that checked each Row, but it repeated each time it found a 1 in the range. I just want it to stop the search if it finds it, and then do action A if it does or aciton B if it doesnt. I also played with Find in ranges and I could not get it to work, andy ideas? Thanks. :banghead: