SteveTheDinosaur
New Member
- Joined
- Dec 28, 2005
- Messages
- 4
Hello eveybody.
I have the following VBA code in different modules in the same project:
Range("A4:I4").Select
With Selection.Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
When the code is executed in one module, the cells are light grey, when I run the same code in another module, I get a sort of browny-orange.
How can this be?
Many thanks to anybody who can help!
I have the following VBA code in different modules in the same project:
Range("A4:I4").Select
With Selection.Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
When the code is executed in one module, the cells are light grey, when I run the same code in another module, I get a sort of browny-orange.
How can this be?
Many thanks to anybody who can help!