ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   cursor position (https://www.excelbanter.com/excel-programming/307702-cursor-position.html)

choice[_2_]

cursor position
 
i have a list that is added to daily. what i would like is for the cursor to
move one cell below the last entry, no matter where the cursor is. example:
last entry is in A56, cursor is in B7, when i hit a button i want the cursor
to go to A57.

Thanks in Advance

Tom Ogilvy

cursor position
 
cells(rows.count,1).End(xlup)(2).Select

--
Regards,
Tom Ogilvy

"choice" wrote in message
...
i have a list that is added to daily. what i would like is for the cursor

to
move one cell below the last entry, no matter where the cursor is.

example:
last entry is in A56, cursor is in B7, when i hit a button i want the

cursor
to go to A57.

Thanks in Advance





All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com