Results 1 to 4 of 4
Like Tree2Likes
  • 1 Post By VoG
  • 1 Post By z2lai

vba Interior.Color

This is a discussion on vba Interior.Color within the Excel Questions forums, part of the Question Forums category; I have a macro where I set a cell's Interior.Color to 11851260 which is a standard light orange. Then when ...

  1. #1
    HWL
    HWL is offline
    Board Regular HWL's Avatar
    Join Date
    Dec 2009
    Posts
    462

    Default vba Interior.Color

    I have a macro where I set a cell's Interior.Color to 11851260 which is a standard light orange. Then when I reset it to the default no fill which is 16777215 the blue grid line is gone and it just looks funky. What am I doing wrong? Maybe something besides Interior.Color?

    SAMPLE CODE to test
    Code:
     
    range("a1").Interior.color = 11851260 'light orange
    range("a1").Interior.color = 16777215 'no fill
    Thanks for any ideas

  2. #2
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    62,269

    Default Re: vba Interior.Color

    Perhaps

    Code:
    Range("A1").Interior.ColorIndex = xlNone
    z2lai likes this.
    HTH, Peter
    Please test any code on a copy of your workbook.

  3. #3
    HWL
    HWL is offline
    Board Regular HWL's Avatar
    Join Date
    Dec 2009
    Posts
    462

    Default Re: vba Interior.Color

    Quote Originally Posted by VoG View Post
    Perhaps

    Code:
    Range("A1").Interior.ColorIndex = xlNone
    That did it! Now just out of curiousity and consistency; I wonder what the .Interior.ColorIndex would be for the .Interior.Color = 11851260 'light orange.

    Is there are table/matrix somewhere?
    Thanks much

  4. #4
    New Member
    Join Date
    Oct 2013
    Posts
    2

    Default Re: vba Interior.Color

    Not sure if you already found one since you posted this a long time ago, but maybe for anyone who's reading this for answers:
    There's a 56 ColorIndex chart that I found on Color Palette and the 56 Excel ColorIndex Colors. Unfortunately it doesn't have the Color Chart with those big numbers, but hopefully you can use the ColorIndex chart to find the light orange you want.
    HWL likes this.

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
  •  


DMCA.com