View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default How do I go to a specific column?

Hi Peter,

It is rarely necessary or desirable to make selections.

Perhaps you could use (or modify) the following:

Cells(Rows.Count, "A").End(xlUp). _
Offset(0, 4).Formula = "=Today()"


Or to enter a static date:


Cells(Rows.Count, "A").End(xlUp).Offset(0, 4) = Date


---
Regards,
Norman



"petergamels" wrote in message
...
I have a spreadsheet of jobs. I can go to the next line and enter new
number
but cannot GoTo column say 5 to enter "TODAY".
Thanks in anticipation of help.
--
prd