W
wal50
I can usually find a similar previous question but not this time.
I can find the last row:
Dim lastrow As Long
lastrow = Cells(Rows.Count, "A").End(xlUp).Row
How do I select a range of columns in the last row +1?
My butchered attempt that doesn't work:
Range(E" & lastrow + 1":L" & lastrow +1").select
Thanks in advance.
wal50
I can find the last row:
Dim lastrow As Long
lastrow = Cells(Rows.Count, "A").End(xlUp).Row
How do I select a range of columns in the last row +1?
My butchered attempt that doesn't work:
Range(E" & lastrow + 1":L" & lastrow +1").select
Thanks in advance.
wal50