Simple question regarding dynamic ranges in VBA

[Jameo]

Hi guys,

I would just like to know what you think would be the best way of referring to the following dynamic range in VBA?

=OFFSET('Imported Fuel Usage Data'!$A$8,0,0,COUNT('Imported Fuel Usage Data'!$A:$A),2)

I simply want to select and copy the range, the data set will vary every time it is used.

Thanks for the help.

 

[JackDanIce]

Something like:

Dim i as Long
With Sheets("Imported Fuel Usage Data")
  i = .Range("A" & Rows.Count).End(xlUp).Row
  .Range("A8:A" & i).Copy
End With

 

[MrKowz]

You'll want to define a Last-Row variable, then refer to the range using that variable:

Dim LR as Long
LR = Range("A" & Rows.Count).End(xlUp).Row
Range("A8:A" & LR).Copy

 

[Jameo]

Thanks guys,

Much obliged