Need help Copying dynamic row ranges

[ajr123]

I am currently working on a project that
requires me to select a range of rows based on the last un used cell in one column which is linked to an access database. This data range changes dailly. When I try to do this it only allows me to select and copy either the top or bottom row of the data .Can someone help me figure this out . Thanks
The last formula I tried is:

Sub SELECT_ROW()
Rows("3:3").Select
Lastrow = Range("A65536").End(xlUp).Row
Rows(Lastrow & ":" & Lastrow).Select
Rows("3:3").Select
Lastrow = Range("A65536").End(xlUp).Row
Rows(Lastrow & ":" & Lastrow).Activate
Selection.Copy
End Sub

 

[Tom Urtis]

See if something like this is what you're after, if I understand you correctly:

Sub SelectRows()
Range([A3], [A65536].End(xlUp)).EntireRow.Select
End Sub

Since you are copying the rows, you can replace the word "Select" with the word "Copy", to save a step.

Any help?