VBA syntax

[normpam]

I would like to use VBA to select a range of cells on another sheet in the workbook but I'm afraid I'm missing part of the syntax. I was thinking along the lines of:

ActiveWorkbook.Sheets.("DATA"). Range("A1, A1.Offset.End(xlDown)).Select

Or something like that.

Help Please?

Thanks!

 

[John Davis]

I would like to use VBA to select a range of cells on another sheet in the workbook but I'm afraid I'm missing part of the syntax. I was thinking along the lines of:

ActiveWorkbook.Sheets.("DATA"). Range("A1, A1.Offset.End(xlDown)).Select

Or something like that.

Help Please?

Thanks!

Maybe

Sheets("DATA").Range(Range("A1"), Range("A1").End(xlDown)).Select