Excel cursor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

billrl34 - 16 Dec 2005 14:55 GMT

Is there a simply way to have the cursor in an Excel spreadsheet, once
it reaches a certain cell due to macro movement, to automatically jump
back to Column A.

Signature

billrl34

Reply to this Message

Dave Peterson - 16 Dec 2005 15:14 GMT

Select your range first (say a1:E55) and then you can tab through the selection.

If you change
tools|options|edit tab|move selection after enter
to right

You can use the enter key, too.

(Things are slightly different if the sheet is protected, though.)

> Is there a simply way to have the cursor in an Excel spreadsheet, once
> it reaches a certain cell due to macro movement, to automatically jump
[quoted text clipped - 5 lines]
> billrl34's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29533
> View this thread: http://www.excelforum.com/showthread.php?threadid=494139

Signature

Dave Peterson

Reply to this Message

billrl34 - 16 Dec 2005 15:29 GMT

Thanks for the help. I did what you suggested but my cursor moved to the
next cell which was blank and it did not jump back to Column A after it
reached the last column in my range. Can you help further?

Signature

billrl34

Reply to this Message

billrl34 - 16 Dec 2005 15:37 GMT

Can I make it loop back even if I am using arrow keys instead of tab

Reply to this Message

Dave Peterson - 16 Dec 2005 16:24 GMT

The arrow keys change the selection.

Does this mean you got the tab/enter key to work?

> Can I make it loop back even if I am using arrow keys instead of tab?
>
[quoted text clipped - 3 lines]
> billrl34's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29533
> View this thread: http://www.excelforum.com/showthread.php?threadid=494139

Signature

Dave Peterson

Reply to this Message

billrl34 - 16 Dec 2005 16:33 GMT

Yes. If I use the tab or enter key at the last used cell, I jump back to
column A. What about using the arrow keys. Can we cause the cursor to
jump to Col. A if using arrow keys?

Signature

billrl34

Reply to this Message

Dave Peterson - 16 Dec 2005 17:09 GMT

The arrow keys change the selection. So no.

> Yes. If I use the tab or enter key at the last used cell, I jump back to
> column A. What about using the arrow keys. Can we cause the cursor to
[quoted text clipped - 5 lines]
> billrl34's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29533
> View this thread: http://www.excelforum.com/showthread.php?threadid=494139

Signature

Dave Peterson

Reply to this Message

billrl34 - 16 Dec 2005 17:58 GMT

I am using a macro to read thru the columns of data. Is there a way t
adapt my macro, which is attached below, so that after reading the las
column in my range the cursor jumps back to column A?

MY MACRO:

Function FunctNextCookie(Optional blnHide As Boolean)
Sheets("C_Data").Select
Cells(3, ActiveCell.Column).Select
' Moves cursor to row 3.
ActiveCell.Offset(0, 1).Range("A1").Select
'Selects next SKU.
Selection.Copy
Sheets("Cookie").Select
Range("C5").PasteSpecial Paste:=xlValues
' Does not HideZeroUsage if called by ReportAll.
If blnHide = True Then HideZeroUsage
End Functio

Reply to this Message

Dave Peterson - 16 Dec 2005 18:12 GMT

You have responses to at your other post.

> I am using a macro to read thru the columns of data. Is there a way to
> adapt my macro, which is attached below, so that after reading the last
[quoted text clipped - 20 lines]
> billrl34's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29533
> View this thread: http://www.excelforum.com/showthread.php?threadid=494139

Signature

Dave Peterson

Reply to this Message