Hi,

I would like to know is there any function in excel which would take
the pointer to Cell L if I hit enter anywhere in row.

For example, say I am on Cell A1 , now if I hit enter the pointer
should go to
L1 and so on.

Thanks in advance.


--
mangesh


------------------------------------------------------------------------
mangesh's Profile: http://www.excelforum.com/member.php...fo&userid=6746
View this thread: http://www.excelforum.com/showthread...hreadid=525248

There isn't but you could write one:

Public Sub gotoL()

Dim lRow As Long

lRow = ActiveCell.Row

ActiveSheet.Range("L" & CStr(lRow)).Select

End Sub

Assign a key combination to it using the Macro dialog. I did
CTRL+SHIFT+L and whenever you want to navigate to column L just hit
your shortcut.

I forgot to request that you use MEANINGFUL subject lines in the future. The
archives would appreciate it.

--
Don Guillett
SalesAid Software

"mangesh" wrote in
message ...

Hi,

I would like to know is there any function in excel which would take
the pointer to Cell L if I hit enter anywhere in row.

For example, say I am on Cell A1 , now if I hit enter the pointer
should go to
L1 and so on.

Thanks in advance.


--
mangesh


------------------------------------------------------------------------
mangesh's Profile:
http://www.excelforum.com/member.php...fo&userid=6746
View this thread: http://www.excelforum.com/showthread...hreadid=525248

right click sheet tabview codeinsert thischange ,5 to column desiredsave

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 1 Then Exit Sub
Target.Offset(, 5).Select

End Sub
--
Don Guillett
SalesAid Software

"mangesh" wrote in
message ...

Hi,

I would like to know is there any function in excel which would take
the pointer to Cell L if I hit enter anywhere in row.

For example, say I am on Cell A1 , now if I hit enter the pointer
should go to
L1 and so on.

Thanks in advance.


--
mangesh


------------------------------------------------------------------------
mangesh's Profile:
http://www.excelforum.com/member.php...fo&userid=6746
View this thread: http://www.excelforum.com/showthread...hreadid=525248

This can be done with the Worksheet_SelectionChange event macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells(Target.Row, "L").Select
End Sub

To install:
Right click the sheet tab. Choose View Code.
Paste the above code.

HTH
Kostis Vezerides

I think OP wants to put something in the cell before moving the cursor.

--
Don Guillett
SalesAid Software

"vezerid" wrote in message
oups.com...
This can be done with the Worksheet_SelectionChange event macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells(Target.Row, "L").Select
End Sub

To install:
Right click the sheet tab. Choose View Code.
Paste the above code.

HTH
Kostis Vezerides