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