Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel cursor move
Message
De
13/03/2006 10:30:18
Jim Winter
Jim Winter Consulting
Hinesburg, Vermont, États-Unis
 
 
À
13/03/2006 09:59:45
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
01103724
Message ID:
01103738
Vues:
17
>Can someone tell me the correct command to move the cursor to the right or left, or up or down in excel? Suppose we have an Excel object and we have cell B2 selected. Then we want to move the cursor 2 cells to the right (relative not absolute). Try as I might I can't seem to find this command in the macro syntax. All my efforts produce an absolute cell reference, not a relative one.
>
>Thanks for any help.

Use the Offset(n,n) property where the first parameter equals the rows and the second equals the columns.

Regards,
Jim
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform