>>>Hello,
>>>
>>>Where can I find a description of the Excel constants (like xlLeft).
>
>>>An other question is: how to use 'named parameters' with Excel.
>>>TIA
>>>Jean-Pierre
>>
>>Hello Jean-Pierre,
>>
>>The only solution I've found for this problem works with Excel 97.
>>
>>Start Excel and then start VisualBasic Editor. Open a Code-Window and
>
>there
>>type in the constant you want to know. Then klick with the right
>mouse
>button
>>on it and select Quickinfo.
>>
>>By, Jens
>
>Thanks Jens, I will try this. Maybe this is better than my solution:
>writing a macro that fills an Excel cell with the constant.
Just try in menu:
View/Debug/Immediately
and then type your constants (like xlLeft), Excel will then
print it immediately.
Chris Lee
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement