Excel cursor

B

billrl34

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.
 
D

Dave Peterson

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.)
 
B

billrl34

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?
 
D

Dave Peterson

The arrow keys change the selection.

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

billrl34

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?
 
D

Dave Peterson

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
jump to Col. A if using arrow keys?
Click to expand...
 
B

billrl34

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
 
D

Dave Peterson

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
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 Function
Click to expand...
 
Top