I have a variety of data dumps that fill column A only (varies from 30-50 data points/rows).
The data dump starts on cell A5.
Unfortunately the data dumps provide unwanted data on the last of 3 rows - every data dump.
How do I select the rows from A5 to the last data point? The last 3 rows I do not want to copy.
I am able to use OFFSET to jump to a cell - but I am unable to string together offset command with the following code:
The above code is able to copy from A5 right down the last data (includes the last 3 rows I don't need).
The data dump starts on cell A5.
Unfortunately the data dumps provide unwanted data on the last of 3 rows - every data dump.
How do I select the rows from A5 to the last data point? The last 3 rows I do not want to copy.
I am able to use OFFSET to jump to a cell - but I am unable to string together offset command with the following code:
VBA Code:
Range("A5").Select
Range(Selection, Selection.End(xlDown)).Select
The above code is able to copy from A5 right down the last data (includes the last 3 rows I don't need).