Range(Cells(r1, c1), Cells(r2, c2)), whe
(r1,c1) are the row,col of the first cell and (r2,c2) are the row, col
of the last cell. From your query, I suppose r2 =n-th row?


--
protonLeah


------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=563540