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

Thread: Delete interior color

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anybody help me with the following :

    I have to delete the interior color of sheet1 with a macro.
    I don't know how many rows this sheet has.
    (it is variable).
    Many thanks for help.

  2. #2
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Based on your question, it appears you want no cell on the sheet to have color, regardless of whatever range you may be working in.

    In general, removing all the interior color from all the cells of the sheet would look something like this:

    Sub NoColor()
    Cells.Interior.ColorIndex = xlNone
    End Sub

    Maybe there's more to the question though, so if you mentioned the variable range because other cells outside of that range have interior color that must be left alone, please repost.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-21 13:44, Tom Urtis wrote:
    Based on your question, it appears you want no cell on the sheet to have color, regardless of whatever range you may be working in.

    In general, removing all the interior color from all the cells of the sheet would look something like this:

    Sub NoColor()
    Cells.Interior.ColorIndex = xlNone
    End Sub

    Maybe there's more to the question though, so if you mentioned the variable range because other cells outside of that range have interior color that must be left alone, please repost.
    Many thanks Tom, that's what I am looking for.

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
  •