Change it to
Set rng = .Range(.Cells(1, 8), _
.Cells(Rows.Count, 8).End(xlUp))
Co
--
colofnatur
-----------------------------------------------------------------------
colofnature's Profile:
http://www.excelforum.com/member.php...fo&userid=3435
View this thread:
http://www.excelforum.com/showthread.php?threadid=56073