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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    List Fill Range Property

    Guest, Apr 29, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    1,655
    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,861
    Guest
    Sep 3, 2004
  3. jasgrand
    Replies:
    0
    Views:
    1,369
    jasgrand
    Oct 6, 2004
  4. Guest

    Value Property vs Text property

    Guest, Oct 28, 2004, in forum: Microsoft Excel Programming
    Replies:
    4
    Views:
    544
    Guest
    Oct 31, 2004
  5. GregR

    Fill Default/Fill Copy

    GregR, May 2, 2005, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    362
    GregR
    May 2, 2005
  6. BernzG
    Replies:
    0
    Views:
    2,143
    BernzG
    Aug 19, 2005
  7. 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:
    440
    CAPTGNVR
    Mar 24, 2008
  8. J.W. Aldridge

    Fill/Copy Up to fill blank cells.

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