find last row and select whle row for format
 

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

find last row and select whle row for format
 

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"saziz" wrote in
message ...

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

find last row and select whle row for format
 

I was totally ignoring cell/row thing.
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