Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
more on interior.colorindex issue
the problem i am having(see the interior.colorindex does not work?
thread if you are interested) seems to be specific to the sheet i'm working on. if i try coping the data to another workbook, i get the same problem, even though the code works on other sheets in the workbook. you would think that the following code, .cell(x,x).interior.colorindex = 3, would change the cell color to red. on this specific sheet it actually colors the cell white. i used the following to see what else was off incase their was an offset or something. x=1 gives a blue color, x=2,4-6 is black, and 3 as mentioned above is white. starting at x=7 things seem to be working fine. for x = 1 to 56 ..cell(x,1).interior.colorindex = x next x can anyone think of any sheet properties/settings/voodoo that may cause this. (there is no conditional formatting on the cells). for the time being i will shade using a different color, but i would like to the cause of the problem. tia bst |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
more on interior.colorindex issue
Sounds like the workbook's palette has been customized. See Tools / Options
/ Color and if you want, click Reset (ActiveWorkbook.ResetColors). Regards, Peter T "bst" wrote in message ... the problem i am having(see the interior.colorindex does not work? thread if you are interested) seems to be specific to the sheet i'm working on. if i try coping the data to another workbook, i get the same problem, even though the code works on other sheets in the workbook. you would think that the following code, .cell(x,x).interior.colorindex = 3, would change the cell color to red. on this specific sheet it actually colors the cell white. i used the following to see what else was off incase their was an offset or something. x=1 gives a blue color, x=2,4-6 is black, and 3 as mentioned above is white. starting at x=7 things seem to be working fine. for x = 1 to 56 .cell(x,1).interior.colorindex = x next x can anyone think of any sheet properties/settings/voodoo that may cause this. (there is no conditional formatting on the cells). for the time being i will shade using a different color, but i would like to the cause of the problem. tia bst |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
more on interior.colorindex issue
That was it!
thanks so much, i thought i was going crazy. thanks again bst "Peter T" <peter_t@discussions wrote in : Sounds like the workbook's palette has been customized. See Tools / Options / Color and if you want, click Reset (ActiveWorkbook.ResetColors). Regards, Peter T "bst" wrote in message ... the problem i am having(see the interior.colorindex does not work? thread if you are interested) seems to be specific to the sheet i'm working on. if i try coping the data to another workbook, i get the same problem, even though the code works on other sheets in the workbook. you would think that the following code, .cell(x,x).interior.colorindex = 3, would change the cell color to red. on this specific sheet it actually colors the cell white. i used the following to see what else was off incase their was an offset or something. x=1 gives a blue color, x=2,4-6 is black, and 3 as mentioned above is white. starting at x=7 things seem to be working fine. for x = 1 to 56 .cell(x,1).interior.colorindex = x next x can anyone think of any sheet properties/settings/voodoo that may cause this. (there is no conditional formatting on the cells). for the time being i will shade using a different color, but i would like to the cause of the problem. tia bst |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
more on interior.colorindex issue
Glad you finally found the problem. I had been following your dilemma.
"bst" wrote: That was it! thanks so much, i thought i was going crazy. thanks again bst "Peter T" <peter_t@discussions wrote in : Sounds like the workbook's palette has been customized. See Tools / Options / Color and if you want, click Reset (ActiveWorkbook.ResetColors). Regards, Peter T "bst" wrote in message ... the problem i am having(see the interior.colorindex does not work? thread if you are interested) seems to be specific to the sheet i'm working on. if i try coping the data to another workbook, i get the same problem, even though the code works on other sheets in the workbook. you would think that the following code, .cell(x,x).interior.colorindex = 3, would change the cell color to red. on this specific sheet it actually colors the cell white. i used the following to see what else was off incase their was an offset or something. x=1 gives a blue color, x=2,4-6 is black, and 3 as mentioned above is white. starting at x=7 things seem to be working fine. for x = 1 to 56 .cell(x,1).interior.colorindex = x next x can anyone think of any sheet properties/settings/voodoo that may cause this. (there is no conditional formatting on the cells). for the time being i will shade using a different color, but i would like to the cause of the problem. tia bst |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
more on interior.colorindex issue
me too :)
?B?SkxHV2hpeg==?= wrote in : Glad you finally found the problem. I had been following your dilemma. "bst" wrote: That was it! thanks so much, i thought i was going crazy. thanks again bst "Peter T" <peter_t@discussions wrote in : Sounds like the workbook's palette has been customized. See Tools / Options / Color and if you want, click Reset (ActiveWorkbook.ResetColors). Regards, Peter T "bst" wrote in message ... the problem i am having(see the interior.colorindex does not work? thread if you are interested) seems to be specific to the sheet i'm working on. if i try coping the data to another workbook, i get the same problem, even though the code works on other sheets in the workbook. you would think that the following code, .cell(x,x).interior.colorindex = 3, would change the cell color to red. on this specific sheet it actually colors the cell white. i used the following to see what else was off incase their was an offset or something. x=1 gives a blue color, x=2,4-6 is black, and 3 as mentioned above is white. starting at x=7 things seem to be working fine. for x = 1 to 56 .cell(x,1).interior.colorindex = x next x can anyone think of any sheet properties/settings/voodoo that may cause this. (there is no conditional formatting on the cells). for the time being i will shade using a different color, but i would like to the cause of the problem. tia bst |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
interior.colorindex does not work? | Excel Programming | |||
To reset the Interior.ColorIndex function | Excel Programming | |||
problem with interior.colorindex | Excel Programming | |||
Use of Interior.ColorIndex | Excel Programming | |||
Testing for Interior.ColorIndex | Excel Programming |