Thanks anilsolipuram, that works perfectly. Now im trying to change it
so it works through a range of cells; basically the same as a user
running it for D9, then D10, then D11, etc. etc., except it would do it
all at once.
It seems to me that I can leave this line:
*"VAL = InputBox("enter which cell to search")*
the same...just have a user input a range instead. I'm then trying to
add a For statement after
*"If W.Name < sh_skip Then" *
and then change the next line
*"IF (IsNumeric(Range(VAL).Value) And Range(VAL).Value < "") Then" *
so it searches a single cell in the range. I am not having much luck
though, and any help would be appreciated.

Thanks,

-Steve


--
thephoenix12
------------------------------------------------------------------------
thephoenix12's Profile: http://www.excelforum.com/member.php...o&userid=24336
View this thread: http://www.excelforum.com/showthread...hreadid=381213