Range Function 1

[Bass71]

I am trying to select a range using the RC functionality.

The following code works:

Range ("A11&quot.Select

But this Does Not...

Range ("RC[1]:RC[16]&quot.Select

How can I select a range without specifying the alpha-numeric coordinates?

 

[siqual]

There areseveral ways I know to do this. It would depend on how the data is arranged on the spreadsheet. I think what might work is something like this:
Range(ActiveCell, ActiveCell.End(xlToRight)).Select
This would select a region from the active cell to the end of the data heading to the right. It is the equivalent of high lighting from the active cell using <cntrl> <shift>rt. arrow.

You could also use the offset method:
Range(ActiveCell, ActiveCell.Offset(, 5)).Select

This would select a total of 6 cells, the active cell + 5.

Hope this helps.