Information générale
Catégorie:
COM/DCOM et OLE Automation
>>That works well Sergey, thank you.
>>
>>I need to learn VBA, there is a lot of value there. I think the Excel help will be fine for filling the details, but it is not useful enough because I need to understand the "big picure" first. Do you know af any resource where I can go to for that?
>
>Alex,
>
>Sorry cannot help you with that. For me VBA help has been enough so far but I'm not doing a lot of automation work.
Thank you.
For your information, CELL("cell") does not bring information from the current cell if the second parameter is omitted, but from the last cell that was changed.
From Help:
CELL(info_type,reference)
Reference is the cell that you want information about. If omitted, information specified in info_type is returned for the last cell that was changed.
I'll take this as homework and will report back :) Thanks again.
Précédent
Suivant
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