Find the last row
 

Hi there,

I need to find the last row with data on it.... does anyone have the VB
to do so...?

Thanks and regards

D

*** Sent via Developersdex http://www.developersdex.com ***

Find the last row
 

LastRow = Cells(Rows.Count,"A").End(xlUp).Row

--
HTH

Bob Phillips

"Darin Kramer" wrote in message
...


Hi there,

I need to find the last row with data on it.... does anyone have the VB
to do so...?

Thanks and regards

D

*** Sent via Developersdex http://www.developersdex.com ***

Find the last row
 

Thanks Bob, sorry I was not specific enough in my query.

I want to find the last row of text, and then select everything between
that row and cell a1, copy and paste it into a new sheet.

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***

Find the last row
 

Just column A?

Range("A1").Resize(Cells(Rows.Count,"A").End(xlUp) .Row).Copy
Worksheets("Sheet2").Range("A1")



--
HTH

Bob Phillips

"Darin Kramer" wrote in message
...


Thanks Bob, sorry I was not specific enough in my query.

I want to find the last row of text, and then select everything between
that row and cell a1, copy and paste it into a new sheet.

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***

Find the last row
 

Darin Kramer wrote:
Thanks Bob, sorry I was not specific enough in my query.

I want to find the last row of text, and then select everything
between that row and cell a1, copy and paste it into a new sheet.

i use:

ActiveSheet.UsedRange.Copy

This will copy everything from a1 to the last row and column that is used.

hth, damo