CELLS, CELLS, and more CELLS

[bill]

I've forgotten how to use CELLS to refer to multiple CELLS such as RANGE can.

Thank you.
Bill

 

[Iain Lewis]

Hi Bill,

As Cells is a object of Range I'm not sure you can use Cells this way ( though someone please correct me if I'm wrong ).

The only thing I can think of which comes close is :

Range(Cells(1, 1), Cells(5, 5)).Select

but this is still using cells as an object of range.

 

[bergy]

On 2002-05-07 08:51, bill wrote:
I've forgotten how to use CELLS to refer to multiple CELLS such as RANGE can.

Thank you.
Bill

How about:
RANGE(CELLS(Row1,Col1),CELLS(Row2,Col2)).SELECT

bergy

 

[bergy]

On 2002-05-07 08:51, bill wrote:
I've forgotten how to use CELLS to refer to multiple CELLS such as RANGE can.

Thank you.
Bill

How about:
RANGE(CELLS(Row1,Col1),CELLS(Row2,Col2)).SELECT

bergy