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" <(E-Mail Removed)> wrote in message
news:F429ADB9-0998-4B34-9E46-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
newsA237BC1-2E88-48A4-89D5-(E-Mail Removed)...
> Hi Steve,
>
> I believe that the constant is universal.
>
> However, as I have a badmemory,
> I use: xlNone.
>
>
>
> ---
> Regards.
> Norman
>
>
> "Steven" <(E-Mail Removed)> wrote in message
> news:F429ADB9-0998-4B34-9E46-(E-Mail Removed)...
>> 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)" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
news7F79ABD-A2B4-42F2-9631-(E-Mail Removed)...
> 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)" <(E-Mail Removed)> wrote in
> message news:(E-Mail Removed)...
>>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
>