| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a date to a cell
Hello,
How can I add a date to a cell? I have tried Worksheets("Sheet1").Range("A1").Value = Now But I keep getting a subscript out of range error message. Please help! Thanks. :-) Consuelo |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding a date to a cell
Consuelo
Perhaps you have no Sheet1 ? Gord Dibben Excel MVP XL2002 On Sat, 20 Sep 2003 19:21:44 -0700, "CBG" wrote: Hello, How can I add a date to a cell? I have tried Worksheets("Sheet1").Range("A1").Value = Now But I keep getting a subscript out of range error message. Please help! Thanks. :-) Consuelo |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding a date to a cell
Click the cell you wish to contain the automatic date entry, type
=NOW() or =TODAY() See which one works best for you. "CBG" wrote in message ... Hello, How can I add a date to a cell? I have tried Worksheets("Sheet1").Range("A1").Value = Now But I keep getting a subscript out of range error message. Please help! Thanks. :-) Consuelo |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding a date to a cell
Just a little addition/elaboration to Gordon's excellent advice:
Given your line of code, the only thing that could cause that message would be if you don't have a sheet with a tab name of Sheet1. It might be Sheet 1 (with a space after sheet) or it could be sheet1, but contain one or more spaces tacked on at the front or the back of the name. Try renaming the sheet so you are sure it is named sheet1 with no spaces. -- Regards, Tom Ogilvy CBG wrote in message ... Hello, How can I add a date to a cell? I have tried Worksheets("Sheet1").Range("A1").Value = Now But I keep getting a subscript out of range error message. Please help! Thanks. :-) Consuelo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding A Date To Adjacent Cell | Excel Worksheet Functions | |||
| adding days from one cell with a date in it to another cell | Excel Discussion (Misc queries) | |||
| Adding days to a date cell to get a new date | Excel Worksheet Functions | |||
| Using a date (datevalue) to trigger adding a value to a cell | Excel Worksheet Functions | |||
| Adding a fixed date to a cell | Excel Worksheet Functions | |||
Hybrid Mode
