Color Index
 

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

Color Index
 

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

Color Index
 

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

Color Index
 

Hi Gary,

My apologies!

I failed to see your response when I posted.



---
Regards.
Norman

Color Index
 

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

Color Index
 

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

Color Index
 

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