Fill property

Discussion in 'Microsoft Excel Programming' started by Guest, Jun 6, 2005.

  1. Guest

    Guest Guest

    I am using this line of code to change the Fill color of a cell, it works
    fine but what code can I use to set it back to NO FILL do to certain
    circumstances?
     
    Guest, Jun 6, 2005
    #1
    1. Advertisements

  2. Guest

    Tom Ogilvy Guest

    since you didn't show your line of code, here is a general example:

    ActiveCell.Interior.ColorIndex = xlNone

    --
    Regards,
    Tom Ogilvy

    "sip8316" <> wrote in message
    news:...
    > I am using this line of code to change the Fill color of a cell, it works
    > fine but what code can I use to set it back to NO FILL do to certain
    > circumstances?
     
    Tom Ogilvy, Jun 6, 2005
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    Thanks,

    That did it, and sorry I thought I pasted and copied

    "Tom Ogilvy" wrote:

    > since you didn't show your line of code, here is a general example:
    >
    > ActiveCell.Interior.ColorIndex = xlNone
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    > "sip8316" <> wrote in message
    > news:...
    > > I am using this line of code to change the Fill color of a cell, it works
    > > fine but what code can I use to set it back to NO FILL do to certain
    > > circumstances?

    >
    >
    >
     
    Guest, Jun 6, 2005
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    List Fill Range Property

    Guest, Apr 29, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    1,473
    Bob Flanagan
    Apr 29, 2004
  2. Christian

    Is there a Filename property in PrintOut property

    Christian, Sep 3, 2004, in forum: Microsoft Excel Programming
    Replies:
    4
    Views:
    2,291
    Guest
    Sep 3, 2004
  3. GregR

    Fill Default/Fill Copy

    GregR, May 2, 2005, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    244
    GregR
    May 2, 2005
  4. CAPTGNVR

    Cant get to fill using plus handle to fill serial number-WHY

    CAPTGNVR, Mar 21, 2008, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    224
    CAPTGNVR
    Mar 24, 2008
  5. J.W. Aldridge

    Fill/Copy Up to fill blank cells.

    J.W. Aldridge, Sep 24, 2008, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    637
    timmg
    Sep 26, 2008
Loading...

Share This Page