Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to select data
Hi - I am using v2007 and want to know code for selecting from row 2 to the
end of populated data in a spreadsheet. The length of the data will vary everytime. Any help gratefully nreceived. Thanks. Anita |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to select data
Assuming you mean you want to select entire rows, give this a try...
Dim LastRow As Long LastRow = ActiveSheet.Cells.Find(What:="*", SearchOrder:=xlRows, _ SearchDirection:=xlPrevious, LookIn:=xlFormulas).Row If LastRow 1 Then Range("2:" & LastRow).Select -- Rick (MVP - Excel) "Anita" wrote in message ... Hi - I am using v2007 and want to know code for selecting from row 2 to the end of populated data in a spreadsheet. The length of the data will vary everytime. Any help gratefully nreceived. Thanks. Anita |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to select data
Sub anita()
Dim r As Range, nLastRow As Long Set r = ActiveSheet.UsedRange nLastRow = r.Rows.Count + r.Row - 1 Rows("2:" & nLastRow).Select End Sub -- Gary''s Student - gsnu201001 "Anita" wrote: Hi - I am using v2007 and want to know code for selecting from row 2 to the end of populated data in a spreadsheet. The length of the data will vary everytime. Any help gratefully nreceived. Thanks. Anita |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to select data
Hi,
Try this Rows("2:" & Cells.SpecialCells(xlLastCell).Row).Select -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Anita" wrote: Hi - I am using v2007 and want to know code for selecting from row 2 to the end of populated data in a spreadsheet. The length of the data will vary everytime. Any help gratefully nreceived. Thanks. Anita |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to select data
That may not work correctly. Try this experiment. Go back to the worksheet
with your sample data and type something into any cell on a row, say, ten rows down from the current end of your data. Now delete that entry by selecting the cell and hitting the Delete key on your keyboard. Now run your code and the selection should go down to the row you entered and then erased the entry on (which is, if you used my suggestion, ten rows below the shown end of data). -- Rick (MVP - Excel) "Mike H" wrote in message ... Hi, Try this Rows("2:" & Cells.SpecialCells(xlLastCell).Row).Select -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Anita" wrote: Hi - I am using v2007 and want to know code for selecting from row 2 to the end of populated data in a spreadsheet. The length of the data will vary everytime. Any help gratefully nreceived. Thanks. Anita |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to select data
thanks everyone - I'll give it a go...
"Rick Rothstein" wrote: Assuming you mean you want to select entire rows, give this a try... Dim LastRow As Long LastRow = ActiveSheet.Cells.Find(What:="*", SearchOrder:=xlRows, _ SearchDirection:=xlPrevious, LookIn:=xlFormulas).Row If LastRow 1 Then Range("2:" & LastRow).Select -- Rick (MVP - Excel) "Anita" wrote in message ... Hi - I am using v2007 and want to know code for selecting from row 2 to the end of populated data in a spreadsheet. The length of the data will vary everytime. Any help gratefully nreceived. Thanks. Anita . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Code to select cells with data | Excel Programming | |||
Code to select cells with data | Excel Programming | |||
VBA code to select data from table into combobox | Excel Programming | |||
Select other workbook to select data in a macro. | Excel Programming |