Hi,
I'm probably being really stupid here but I have two different sets of data on the same worksheet.
I know how to find the last row of data on the entire worksheet even with empty cells.
I know how to find all rows of selected data for the first range, e.g. B2:B10 has data and B15:B20 has data but I'm only selecting the first range using
Question is, how am I able to define the last row of the first range, e.g. B10 and not to select the whole range from B2?
I know the answer is something simple so hopefully I'll figure it out before someone replies
I'm probably being really stupid here but I have two different sets of data on the same worksheet.
I know how to find the last row of data on the entire worksheet even with empty cells.
I know how to find all rows of selected data for the first range, e.g. B2:B10 has data and B15:B20 has data but I'm only selecting the first range using
Code:
Range(Range("B2"), Range("B2").End(xlDown)).Select
Question is, how am I able to define the last row of the first range, e.g. B10 and not to select the whole range from B2?
I know the answer is something simple so hopefully I'll figure it out before someone replies