Hi All,

Here is the code I am trying to select last row.

iRow = .Cells(.Rows.Count, 2).End(xlUp).Row
.Cells(iRow, 1).Select

It just select last cell in col. A. I like to select the whole row.
Any help please
Thank you
Syed.


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=507505