| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date function
I have a vba program that creating a seperate excel sheet. I want to
have a date entered on the created sheet for when it was created. This date would be static and not change each time the new sheet was opened or saved. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
date function
Run this after you have created and Activated the sheet:
Sub marine() Range("A1").Value = Date End Sub -- Gary''s Student - gsnu200766 " wrote: I have a vba program that creating a seperate excel sheet. I want to have a date entered on the created sheet for when it was created. This date would be static and not change each time the new sheet was opened or saved. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
date function
Do you want to place the date in a cell? If so, try this:
Sub CreateSheetWithDate() Dim wks As Worksheet Set wks = Sheets.Add Range("a1").Value = "This sheet created on: " & Date End Sub HTH, Matthew Pfluger " wrote: I have a vba program that creating a seperate excel sheet. I want to have a date entered on the created sheet for when it was created. This date would be static and not change each time the new sheet was opened or saved. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to lookup date on tab in excel and populate date on calen | Excel Worksheet Functions | |||
| Difference betwen Excel Date () Function and System Date | Excel Worksheet Functions | |||
| Function Excel:If a Dateactual date create a RED alert in a cel? | Excel Programming | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Linear Mode
