selected cell governs go to command

[mbnspect]

I would like to go to the "K"cell on the row I am currently working on.
edit>go to>K But without having to write what row number I am on. I
would like the the fact that any cell selected on the row will cause my go to
command to select the K cell of that row. K:k selects the whole K column.
I want to select the K cell of the particular row I am currently in without
having to enter the row number.

 

[Gary''s Student]

run this small macro:

Sub mersion()
Application.Goto reference:=Range("K" & ActiveCell.Row)
End Sub

 

[Gord Dibben]

You didn't like the macro I posted yesterday when you asked same question?

You cannot do what you want without a macro. Go to "K" has no meaning to Excel
unless "K" is a named range.

Sub foo()
Dim myrow As Long
myrow = ActiveCell.Row
Range("K" & myrow).Select
End Sub


Gord Dibben MS Excel MVP