Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving in Excel
Message
From
15/07/2002 11:48:42
 
 
To
12/07/2002 17:41:27
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Miscellaneous
Thread ID:
00678140
Message ID:
00678717
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
Thanks JCF, iappreciate it.
Winn Pauley
Previous
Reply
Map
View

Click here to load this message in the networking platform