Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel cell reference
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
01230317
Message ID:
01230340
Vues:
16
Thanks Hugo. Your hint pointed me in the right direction and I found:
.activecell.address
which is what I was looking for.

Thanks

>Don,
>
>ActiveCell?
>
>if not isnull(oExcel.ActiveCell)
>  ? oExcel.ActiveCell.Row, oExcel.ActiveCell.Column, oExcel.ActiveCell.Value, oExcel.ActiveCell.Text
>endif
>
>
>>Assuming I'm using oExcel but have no way of knowing what cell the cursor is currently in, how can I get a text variable containing a reference to the current cell?
>>
>>Something like:
>>
>>lcCurrentcell = oExcel.selection
>>
>>
>>Thanks for any help here. I couldn't figure out how to test this with a macro.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform