I see that we need to replace the "e_range.Address" in this:
TEMP = TEMP & E_RANGE.ADDRESS & CHR(10)
I am not sure, however, what to replace it with, to get the names from
column B.
--
thephoenix12
------------------------------------------------------------------------
thephoenix12's Profile:
http://www.excelforum.com/member.php...o&userid=24336
View this thread:
http://www.excelforum.com/showthread...hreadid=381213