find last row and select whle row for format

S

saziz

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.
 
B

Bob Phillips

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top