Results 1 to 4 of 4

Thread: What color is a table Header?

Hybrid View

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    What color is a table Header?

    Given a table in Excel, how do I determine what the color of the header is? What I'm trying to do is if a row in table2 = a row in table1, color table2's row the color of table1's header.

  2. #2
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,393

  3. #3

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Re: What color is a table Header?

    Thanks (and I really mean that) but the first link applies only to Word, I know how to do the second but it doesn't answer my question, and the 3rd, while valuable, again doesn't answer my question.

  4. #4
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,393

    Re: What color is a table Header?

    Actually, link 3 above has the information you need:

    Code:
    intColor = Sheet1.ListObjects("Table1").HeaderRowRange.Interior.ColorIndex ' Replace Table1 with your Table Name

Posting Permissions

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



Click Here to Expand Forum to Full Width