| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
