Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Aloisa Miller   on Mar 07 In MS Office Category.

  
Question Answered By: Chaths Massri   on Mar 07

For number 2 & 3, below is a function I wrote a while back. The
syntax is =Color(A1). This will tell you the number value of the
color. Excel00 has 56 colors and I think -4142 is empty or white, I
can't remember.


Function Color(arg1)
'Created by BJeffery
'12/14/04

Color = arg1.Interior.ColorIndex
End Function

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How to Use Excel Objects ? Or get search suggestion and latest updates.


Tagged: