ExcelBanter - Change worksheet tab colors failing

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Change worksheet tab colors failing (https://www.excelbanter.com/excel-programming/423435-change-worksheet-tab-colors-failing.html)

John

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

joel

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

All times are GMT +1. The time now is 03:12 PM.