ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Move the cursor to the next row (https://www.excelbanter.com/excel-programming/385308-move-cursor-next-row.html)

danhattan

Move the cursor to the next row
 
Hi all.

What is the command to move the cursor from the cell it is in, to the cell
directly below it? Tried searching help and just got info on SmallScroll, End
and Rows. None of these are what I'm looking for.

Thanks in advance for any help provided.

Dan

Roger Govier

Move the cursor to the next row
 
Hi

Try
activecell.Offset(1,0).Select

--
Regards

Roger Govier


"danhattan" wrote in message
...
Hi all.

What is the command to move the cursor from the cell it is in, to the
cell
directly below it? Tried searching help and just got info on
SmallScroll, End
and Rows. None of these are what I'm looking for.

Thanks in advance for any help provided.

Dan




danhattan

Move the cursor to the next row
 
Did just what I needed. Thanks much for the help.

"Roger Govier" wrote:

Hi

Try
activecell.Offset(1,0).Select

--
Regards

Roger Govier


"danhattan" wrote in message
...
Hi all.

What is the command to move the cursor from the cell it is in, to the
cell
directly below it? Tried searching help and just got info on
SmallScroll, End
and Rows. None of these are what I'm looking for.

Thanks in advance for any help provided.

Dan






All times are GMT +1. The time now is 08:10 PM.

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