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.

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.
--
Kevin Backmann


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

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.

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.

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.

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.


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.

--

Dave Peterson