HWL
Active Member
- Joined
- Dec 1, 2009
- Messages
- 462
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
Thanks for any ideas
SAMPLE CODE to test
Code:
range("a1").Interior.color = 11851260 'light orange
range("a1").Interior.color = 16777215 'no fill
Thanks for any ideas