Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date upon open
i have a simple spreadsheet that i open about once a week that i enter data
in one line at a time. i want the date to be entered at the bottom of column h in the first row after the last entry from the previous weeks entry. 3 march 12 2004 21 march 19 xxxxxx <- puts here when it opens i know its somehthing like.. Private Sub Workbook_Open() range(h'somethine')=Format(Now(), "mmmm d, yyyy") end sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
date upon open
Try:
Private Sub Workbook_Open() Range(h & Range("H1".Currentregion.rows.count + 1) = Date End Sub Aslong as the list starts in cell H1 and column H is formated as a date - it should appear correctly "Lawson" wrote: i have a simple spreadsheet that i open about once a week that i enter data in one line at a time. i want the date to be entered at the bottom of column h in the first row after the last entry from the previous weeks entry. 3 march 12 2004 21 march 19 xxxxxx <- puts here when it opens i know its somehthing like.. Private Sub Workbook_Open() range(h'somethine')=Format(Now(), "mmmm d, yyyy") end sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
date upon open
Sorry missed a bracket
Private Sub Workbook_Open() Range(h & Range("H1".Currentregion.rows.count + 1)) = Date End Sub "CPBro" wrote: Try: Private Sub Workbook_Open() Range(h & Range("H1".Currentregion.rows.count + 1) = Date End Sub Aslong as the list starts in cell H1 and column H is formated as a date - it should appear correctly "Lawson" wrote: i have a simple spreadsheet that i open about once a week that i enter data in one line at a time. i want the date to be entered at the bottom of column h in the first row after the last entry from the previous weeks entry. 3 march 12 2004 21 march 19 xxxxxx <- puts here when it opens i know its somehthing like.. Private Sub Workbook_Open() range(h'somethine')=Format(Now(), "mmmm d, yyyy") end sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Closed Date < 2 weeks of Open Date etc | Excel Worksheet Functions | |||
Date open file with date saved | Excel Worksheet Functions | |||
Always open a certain worksheet if date is past? | Excel Discussion (Misc queries) | |||
How do get I my schedule to open at the current date? | Excel Worksheet Functions | |||
When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions |