Selecting all data in specific columns without selecting adjacent column.

Hello All,

I thought I already posted the following, but I cannot find it and did not receive a confirmation e-Mail.

Using VBA, I need to Select A1:C14.

The problem is that A1:C14 contains blank cells, and there is also an adjacent column D that I do not want to copy.

So, UsedRegion and CurrentRegion aren't doing it for me. (It selects Column D too.)

Obviously, this is an example...the real data set is an export and varies in size.

Option Explicit

Sub test()
Range("A1:C" & Range("C" & Rows.Count).End(xlUp).Row).Select
End Sub