If a cell has no color index attached is it's Interior.ColorIndex -4142 for
everyone or can it be different on different computers?

Thank you,

Steven

Perhaps not for MACs.

Consider xlNone
--
Gary''s Student - gsnu200789


"Steven" wrote:

If a cell has no color index attached is it's Interior.ColorIndex -4142 for
everyone or can it be different on different computers?

Thank you,

Steven

Hi Steve,

I believe that the constant is universal.

However, as I have a badmemory,
I use: xlNone.



---
Regards.
Norman


"Steven" wrote in message
...
If a cell has no color index attached is it's Interior.ColorIndex -4142
for
everyone or can it be different on different computers?

Thank you,

Steven

Hi Gary,

My apologies!

I failed to see your response when I posted.



---
Regards.
Norman

I think it is always better to use the built-in VB constants (such as
xlNone, vbLf, etc.) than the so called "magic numbers" (such as -4142, 10,
etc.) as the built-in constants go a long way to making your code
self-documenting.

Rick


"Norman Jones" wrote in message
...
Hi Steve,

I believe that the constant is universal.

However, as I have a badmemory,
I use: xlNone.



---
Regards.
Norman


"Steven" wrote in message
...
If a cell has no color index attached is it's Interior.ColorIndex -4142
for
everyone or can it be different on different computers?

Thank you,

Steven

Hi Rick,

I always use the named constants (within
Excel); my 'bad memory' was merely an
artifice to render the implicit suggestion more
palatable!



---
Regards.
Norman
"Rick Rothstein (MVP - VB)" wrote in
message ...
I think it is always better to use the built-in VB constants (such as
xlNone, vbLf, etc.) than the so called "magic numbers" (such as -4142, 10,
etc.) as the built-in constants go a long way to making your code
self-documenting.

Rick

And my comments were not directed to you specifically, rather, they were
directed to the community at large (either within this thread or the
archives)... your message was just a convenient 'vehicle' with which to make
my point.

Rick


"Norman Jones" wrote in message
...
Hi Rick,

I always use the named constants (within
Excel); my 'bad memory' was merely an
artifice to render the implicit suggestion more
palatable!



---
Regards.
Norman
"Rick Rothstein (MVP - VB)" wrote in
message ...
I think it is always better to use the built-in VB constants (such as
xlNone, vbLf, etc.) than the so called "magic numbers" (such as -4142, 10,
etc.) as the built-in constants go a long way to making your code
self-documenting.

Rick