Issue w/ Current Region, Select 3 Columns of Data without selecting adjacent columns

Hello,

How can I dynamically (using VBA) select D1:F9 ONLY (the range has spaces in it)? I have attached a workbook.

The real data set changes in size every day, but I will need to always copy the same three columns.

Option Explicit

Sub test()
Range("D1:F" & Range("D" & Rows.Count).End(xlUp).Row).Select
End Sub

Nice! I appreciate that.