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 |
#2
|
|||
|
|||
Did you mean want to select a row three row after the last row? Sheets("Sheet4").Rows(lngLastRow + 3).Select -- hideki ------------------------------------------------------------------------ hideki's Profile: http://www.excelforum.com/member.php...o&userid=18903 View this thread: http://www.excelforum.com/showthread...hreadid=397766 |
#3
|
|||
|
|||
I want to select rows 3 to lngLastRow (in this case, lngLastRow = 203). But the value of lngLastRow may change in the future as items in the table I'm creating are modified. -- Coolboy55 ------------------------------------------------------------------------ Coolboy55's Profile: http://www.excelforum.com/member.php...o&userid=26508 View this thread: http://www.excelforum.com/showthread...hreadid=397766 |
#4
|
|||
|
|||
I also will want to use xlLastCell to pick a range, as in, Range("B3:xlLastCell"). How can I do that? I'm basically creating a table for my data, along with background shading. The data in the table will change occasionally, so the borders and shading will need to be reapplied and resized as necessary. Am I doing it wrong? -- Coolboy55 ------------------------------------------------------------------------ Coolboy55's Profile: http://www.excelforum.com/member.php...o&userid=26508 View this thread: http://www.excelforum.com/showthread...hreadid=397766 |
#5
|
|||
|
|||
So you want to select the range from B3 to the last cell? I think you can try this syntax. Range(Cells(3, "B"), Cells.SpecialCells(xlCellTypeLastCell)).Select -- hideki ------------------------------------------------------------------------ hideki's Profile: http://www.excelforum.com/member.php...o&userid=18903 View this thread: http://www.excelforum.com/showthread...hreadid=397766 |
Reply |
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 |