G'day guys, I know there is a simple answer to this. I am searching a
column of values and want to stop when I hit text. Is there any way to
write a simple if statement that says "If next cell does not equal an
integer, exit sub"?

example: in the below example I find the load case (say load1) then
search under it for node 404. As 404 is not there I need it to stop at
load2 and not continue to the 404 value.

load1
401
405
410
417
418
load2
404
407
413
415
418
419

thanks for your help.


--
nelg
------------------------------------------------------------------------
nelg's Profile: http://www.excelforum.com/member.php...o&userid=27771
View this thread: http://www.excelforum.com/showthread...hreadid=495408