| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locate a column, sum specific columns to the right of that column | Excel Discussion (Misc queries) | |||
| Insert Column after specific text title the new column and add for | Excel Discussion (Misc queries) | |||
| Sum specific column rows based on 2 different column criteria | Excel Worksheet Functions | |||
| How do I update Column #1 based on specific value of column #2? | Excel Worksheet Functions | |||
| SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions | |||
Linear Mode
