Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Could anyone suggest any general reasons why this code might report:
"Unable to set the colorindex property of the interior class"? with target blah blah blah .Offset(0, 0).Resize(1, 10).Interior.ColorIndex = 40 'Tan Core Infrastructure yada yada yada end with I can select the range in a similar way using ..offset(0,0).resize(1,10).select, and the worksheet isn't protected. Send me home happy for the weekend! Thanks in advance Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rephrasing Interior.ColorIndex 36 question. | New Users to Excel | |||
Selection.Interior.ColorIndex = 0 Error | Excel Programming | |||
Use of Interior.ColorIndex | Excel Programming | |||
VBA syntax for Font & Interior ColorIndex | Excel Discussion (Misc queries) | |||
Testing for Interior.ColorIndex | Excel Programming |