How do I go to a specific column?
 

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

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