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