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

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

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

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

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