| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
