Prev: Repeat a marco with number of times or loop until End
Next: "Invalid use of Property" message
From: Anita on 28 Mar 2010 13:09
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" <Anita(a)discussions.microsoft.com> wrote in message
> news:06E7F1F1-BB74-4992-A444-4208C569E002(a)microsoft.com...
> > 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
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Repeat a marco with number of times or loop until End
Next: "Invalid use of Property" message