That sort of works. This part needs to be changed:
IF TRIM(RANGE(\"B\" & E_RANGE.ROW).VALUE) < \"\" THEN
I need it to be not the part from row b, but actually cells within the
range that were entered. But if I try to just put
IF TRIM(RANGE(E_RANGE).VALUE) < \"\" THEN
it gives me an error. Just to check to see if this worked though, I
had my range be in column d, and replaced the "b" with "d" and it did
work. So I just need to know what to put instead of just e_range.
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