selected cell governs go to command
 

I would like to go to the "K"cell on the row I am currently working on.
editgo toK 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.

selected cell governs go to command
 

run this small macro:

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

--
Gary''s Student - gsnu200765


"mbnspect" wrote:

I would like to go to the "K"cell on the row I am currently working on.
editgo toK 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.

selected cell governs go to command
 

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

On Fri, 11 Jan 2008 09:24:02 -0800, mbnspect
wrote:

I would like to go to the "K"cell on the row I am currently working on.
editgo toK 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.