Select Data xlDown -1 VBA

[Bench]

Hi,

looking for a way to select data, beginning at A4:C4 down to the bottom of the range but excluding the final line which will be Grand Total line. The selected data will be used to make a chart.

Any ideas?

Thanks

Ben

 

[Norie]

You could try this.

Set rngData = Range(Range("A4"), Range("A4").End(xlDown).Offset(-1)).Resize(, 3)
 
rngData.Select

A couple of points though.

1 You shouldn't need to use Select.

2 Determining the no of rows of data is normally better done by starting at the bottom not the top, ie using xlUp.

 

[Bench]

You could try this.

Set rngData = Range(Range("A4"), Range("A4").End(xlDown).Offset(-1)).Resize(, 3)
 
rngData.Select

A couple of points though.

1 You shouldn't need to use Select.

2 Determining the no of rows of data is normally better done by starting at the bottom not the top, ie using xlUp.

Perfect, thanks