Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel - Last Cell, row, col
Message
From
09/08/1999 19:33:06
 
 
To
All
General information
Forum:
Visual Basic
Category:
VBA
Title:
Excel - Last Cell, row, col
Miscellaneous
Thread ID:
00251828
Message ID:
00251828
Views:
67
How can I get the last row or cell or column selected/modified? I keep getting the next cell after the enter. For example if I have code in place to act upon a cell or row and I add "joe" to cell A1 and press enter. The selected cell is now A2 so "joe" in A1 is not acted upon as desired. Any helpful directions would be appreciated. I have the need for the last cell, row, and column.

AdvThanksance
~Joe Johnston USA

"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams

Next
Reply
Map
View

Click here to load this message in the networking platform