| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change worksheet tab colors failing
I'm using the following code to clear the colors from a worksheet tab and am
getting a "Subscript out of range" error: Sheets("aaaDetail").Range("$A$1").Select Sheets("aaaDetail").Tab.ColorIndex = xlAutomatic The first statement selects cell A1 fine, but the second errors. I appreciate your help, -John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change worksheet tab colors failing
from
Sheets("aaaDetail").Tab.ColorIndex = xlAutomatic to Sheets("aaaDetail").Tab.ColorIndex = -4142 "John" wrote: I'm using the following code to clear the colors from a worksheet tab and am getting a "Subscript out of range" error: Sheets("aaaDetail").Range("$A$1").Select Sheets("aaaDetail").Tab.ColorIndex = xlAutomatic The first statement selects cell A1 fine, but the second errors. I appreciate your help, -John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Colors on worksheet change when printing | Excel Discussion (Misc queries) | |||
| can you change the colors of a header in excel worksheet | Excel Discussion (Misc queries) | |||
| change all of the same fill colors in a worksheet | Excel Worksheet Functions | |||
| How do I change worksheet tab colors when it is not an option, | Excel Discussion (Misc queries) | |||
| Change worksheet tab colors | Excel Discussion (Misc queries) | |||
Hybrid Mode
