Thread: Color Index
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_2035_] Rick Rothstein \(MVP - VB\)[_2035_] is offline
external usenet poster
 
Posts: 1
Default 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