| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting multi rows
I wish to select rows from row FstRw to row LstRw where FstRw and LstRw are
established by my previous code. I can only find reference to selecting a single row as a variable and multi rows by fixed row numbers. Any help would be much appreciated. Thanks Derek Mansfield |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting multi rows
Hi Derek
Try this frow = 12 Lrow = 20 Rows(frow & ":" & Lrow).Select -- Regards Ron de Bruin http://www.rondebruin.nl "Derek Mansfield" wrote in message .uk... I wish to select rows from row FstRw to row LstRw where FstRw and LstRw are established by my previous code. I can only find reference to selecting a single row as a variable and multi rows by fixed row numbers. Any help would be much appreciated. Thanks Derek Mansfield |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting multi rows
Range("A" & FstRw).Resize(LstRw - FstRw + 1).Select or Range(Cells("A" & FstRw), Cells(LstRw,"A")) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Derek Mansfield" wrote in message .uk... I wish to select rows from row FstRw to row LstRw where FstRw and LstRw are established by my previous code. I can only find reference to selecting a single row as a variable and multi rows by fixed row numbers. Any help would be much appreciated. Thanks Derek Mansfield |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting multi rows
Hi Ron,
Thanks very much. Exactly what I was looking for. Regards, Derek Mansfield "Ron de Bruin" wrote: Hi Derek Try this frow = 12 Lrow = 20 Rows(frow & ":" & Lrow).Select -- Regards Ron de Bruin http://www.rondebruin.nl "Derek Mansfield" wrote in message .uk... I wish to select rows from row FstRw to row LstRw where FstRw and LstRw are established by my previous code. I can only find reference to selecting a single row as a variable and multi rows by fixed row numbers. Any help would be much appreciated. Thanks Derek Mansfield |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using CodeName when Selecting Multi-Tabs | Excel Programming | |||
| colating multi rows of data into single rows - no to pivot tables! | Excel Worksheet Functions | |||
| Selecting a subset of data from multi columns | Excel Discussion (Misc queries) | |||
| after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
| Multi Check Boxes (Selecting Just One) | Excel Programming | |||
Linear Mode
