Hi,
Im having a hard time trying to do the following.
I want my macro to copy a range, but the range will always be different. I would like to find the last cell with data in column B, and the returned row will be the last row in my range. Then, I would like to select A1:D(whatever row the search in B returned). I can find the last row in B with :
Worksheets("Changes Sheet").Range("B65536").End(xlUp)
But how do i specify the range A1 to D and this row?
Many thanks!
Im having a hard time trying to do the following.
I want my macro to copy a range, but the range will always be different. I would like to find the last cell with data in column B, and the returned row will be the last row in my range. Then, I would like to select A1:D(whatever row the search in B returned). I can find the last row in B with :
Worksheets("Changes Sheet").Range("B65536").End(xlUp)
But how do i specify the range A1 to D and this row?
Many thanks!