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
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?
Like this thread? Share it with others