I want to select and copy a range of variable size. I know the the first
row of the range is from "G3:M3" However, I don't know how many rows deep
the range will be. Sometimes the Range may be ("G3:M27") or ("G3:M15").
Additionally, I want to select everything EXCEPT the last row in the range.
Also, there is other data below the first range of data that I don't want, so
using Range("G65536").End(xlUp) won't work either.
I used the following code and I keep getting Error '91' Object variable or
With block variable not set.
I think it's close to doing what I want it to do?!
Sub lastrow()
Dim lastrow As Range
Sheets("sheet1").Select
lastrow = Range("g3:m3").End(xlDown).Row - 1
Range("g3" & lastrow).Select
End Sub
Suggestions?