Please help me

[mangesh]

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.

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

[Don Guillett]

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

--
Don Guillett
SalesAid Software
[email protected]
"mangesh" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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
--
Don Guillett
SalesAid Software
[email protected]
"mangesh" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

[Don Guillett]

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

--
Don Guillett
SalesAid Software
[email protected]
"vezerid" <[email protected]> wrote in message
news:[email protected]...
> 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
>