Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Selecting Rows
I want to select rows 3 to l_LastRow. I can't say Rows("3:l_LastRow"), so what are my alternatives? Thanks! This is what I have: ---------- l_LastRow = Sheet4.Cells.Find(What:=" * ", After:=[A1], SearchDirection:=xlPrevious).Row Sheet4.Rows("3:l_LastRow").Select ---------- -- Coolboy55 ------------------------------------------------------------------------ Coolboy55's Profile: http://www.excelforum.com/member.php...o&userid=26508 View this thread: http://www.excelforum.com/showthread...hreadid=397766 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Selecting rows from cells | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Selecting a large number of rows, but not all | New Users to Excel | |||
Adding Rows to Master Sheet | New Users to Excel |