Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Moving in Excel
Message
De
12/07/2002 17:41:27
 
 
À
12/07/2002 13:11:17
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Titre:
Divers
Thread ID:
00678140
Message ID:
00678293
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform