Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Moving in Excel
Message
De
15/07/2002 11:48:42
 
 
À
12/07/2002 17:41:27
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Titre:
Divers
Thread ID:
00678140
Message ID:
00678717
Vues:
8
>>Hi All,
>>How do I programaticaly move to the end (the cell after the last cell that has info) of a column?
>>TIA,
>
>This is reported by using the macro recorder on an existing spreadsheet. In your code you would probably need to change "Selection" with the reference to your cell or range object. One gotcha to be aware of here is that if there are any empty rows in between the data the selected cell will stop at the previous row, the same behavior as if you are working in Excel interactively.
>
Selection.End(xlDown).Select
Thanks JCF, iappreciate it.
Winn Pauley
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform