Hi, that worked great on the sample sheets I attached, but when I ru
the macro on the actual data I get the following error:

Runtime error '1004'

method 'Range' of object '_Global' failed


Do you have any idea why this would occur? Too long of a list? I hav
over 3000 rows.


Thanks for helping,

Bill Beecha

--
billbeecha
-----------------------------------------------------------------------
billbeecham's Profile: http://www.excelforum.com/member.php...fo&userid=1628
View this thread: http://www.excelforum.com/showthread.php?threadid=39868