VBA - offset rows from bottom data - select above rows in column

[gonsped]

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:

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).

 

[footoo]

Range("A5").Select
Range(Selection, Selection.End(xlDown).Offset(0 - 3)).Select

Or :

Range([A5], [A5].End(4)(-2)).Select

 

[gonsped]

Excellent! - so thats where I have to include the Offset =D