HELP! What's wrong with my code?
 

nm, i got it.

Set rngComb = Range("A1:A" & .Range("A65536").End(xlUp).Row)

should be

Set rngComb = .Range("A1:A" & .Range("A65536").End(xlUp).Row)



wow, what a difference a period makes... :confused

--
Sethaholi
-----------------------------------------------------------------------
Sethaholic's Profile: http://www.excelforum.com/member.php...fo&userid=2511
View this thread: http://www.excelforum.com/showthread.php?threadid=38621