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