ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Command to move down one row (https://www.excelbanter.com/excel-programming/302551-re-command-move-down-one-row.html)

Tom Ogilvy

Command to move down one row
 
ActiveCell.Offset(1,0).Select

or

selection.Offset(1,0).Select

--
Regards,
Tom Ogilvy

" wrote in
message ...
Help! Is there a command to move down one row regardless of where you are

in the spreadsheet? When I use the autorecord, VB selects a specific cell.
Using Selection.End(xlDown).Select sequentially drops it all the way to the
last two. Help!




All times are GMT +1. The time now is 11:14 AM.

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