In a macro..............

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


Gord

On Thu, 10 Jan 2008 13:25:01 -0800, mbnspect
wrote:

Thank you that helps but is there a way to do EditGo To K (but only the K
cell of that particular row that my cursor is currently in without having to
number the row?)

"Gord Dibben" wrote:

Try EditGo To K:K which selects all of column K

As far as the macro goes, no help until we know a lot more details.


Gord Dibben MS Excel MVP

On Tue, 8 Jan 2008 13:38:03 -0800, mbnspect
wrote:

When I click edit then goto the enter Column "K" without any row number, I
get an error message that it not a valid reference or defined name. I want
to ultimately set up a macro that will go to the Column "K" and insert a
"check mark" their. but i want to be able to do it after I have filled in
some of the info on columns A through J. Ultimately I want the cell to have
yellow background.
Can anybody help me with what i thought was a simple matter.