HOW IS COLUMN "K" REFERENCED ON THE CURRENT ROW IN THE GOTO COMMAN

M

mbnspect

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

Kevin B

You could name the first cell in column K and then use the range name to goto
the cell.

Move to the cell you want to name and from the menu click INSERT/NAME/DEFINE

Give a name like CheckMark or something and then use the F5 goto key and
either enter the named range or select from the list of displayed names
directly above the reference field.
 
G

Gord Dibben

Try Edit>Go 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
 
D

Dave Peterson

You can use:

K:K

You could use:

With ActiveSheet
.Range("K1").EntireColumn.Interior.ColorIndex = 3 'whatever
.Range("K:K").EntireColumn.Interior.ColorIndex = 4
.Range("K:k").Interior.ColorIndex = 5
.Columns("K:K").EntireColumn.Interior.ColorIndex = 6
.Columns("K:K").Interior.ColorIndex = 7
.Columns(11).EntireColumn.Interior.ColorIndex = 8
End With

6 was a shade of yellow with my color scheme.
 
M

mbnspect

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

Gord Dibben

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

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


Gord
 
Top