Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: CELLS, CELLS, and more CELLS

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Houston TX
    Posts
    550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    Thank you.
    Bill

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Midlands, UK
    Posts
    217
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    115
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Posts
    115
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •