ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Moving the cursor (https://www.excelbanter.com/excel-programming/389739-moving-cursor.html)

Gandhi Bojja

Moving the cursor
 
I would like to move the cursor to the first or any coloumn in the same row
writing a macro. Can anyone help.

Thanks in advance
--
suresh gandhi

NickHK

Moving the cursor
 
Assuming you not mrean the mouse cursor, but the active cell, here's afew
options:

Range("A1").select
Activecell.offset(10,0).select
Application.Goto Range("IV1")

NickHK

"Gandhi Bojja" wrote in message
...
I would like to move the cursor to the first or any coloumn in the same

row
writing a macro. Can anyone help.

Thanks in advance
--
suresh gandhi




Joerg

Moving the cursor
 
Here is another one:
Activecell.EntireRow.Cells(1).select

This will move the "cursor" to the first column in the same row. For any
other column change the value 1 to the desired column number.

Joerg


"NickHK" wrote in message
...
Assuming you not mrean the mouse cursor, but the active cell, here's afew
options:

Range("A1").select
Activecell.offset(10,0).select
Application.Goto Range("IV1")

NickHK

"Gandhi Bojja" wrote in message
...
I would like to move the cursor to the first or any coloumn in the same

row
writing a macro. Can anyone help.

Thanks in advance
--
suresh gandhi






Gandhi Bojja[_2_]

Moving the cursor
 
Thanks Nick and Joen

suresh gandhi


All times are GMT +1. The time now is 10:29 AM.

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