Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving in Excel
Message
From
12/07/2002 17:41:27
 
 
To
12/07/2002 13:11:17
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Miscellaneous
Thread ID:
00678140
Message ID:
00678293
Views:
9
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform