Please help me

M

mangesh

Hi,

I would like to know is there any function in excel which would tak
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 pointe
should go to
L1 and so on.

Thanks in advance
 
C

chillihawk

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

Don Guillett

right click sheet tab>view code>insert this>change ,5 to column desired>save

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

End Sub
 
D

Don Guillett

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

vezerid

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
 
Top