Nevermind,
I just saw the thread started by Hari that has four examples of what
wanted. i admit my mistake and my stupidity. For the records, i lik
the second example given the best. That was nice. i like how it lai
it out horizontally, and then put the number right in there. super
job
No, because in theory, every workbook has its own color palette which can be
modified by the user. So a ColorIndex of 3 may represent a different color
in different workbooks.
Having said that, most users don't modify the default palette. This macro
will help you to see what ColorIndex represents what color in your workbook:
Sub ShowColors()
Dim i As Integer
For i = 1 To 56
With Cells(i, 1)
.Value = i
.Interior.ColorIndex = i
End With
Next
End Sub
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. After that, you can post your question and our members will help you out.
