View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default HOW IS COLUMN "K" REFERENCED ON THE CURRENT ROW IN THE GOTO COMMAN

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.