Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Date and time in Cell
Hello,
I am looking for a line of code that I could add to the end of my macro that would insert the date and time the macro was first run into a cell named "vLeadWriteDate". Any help would be great. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Date and time in Cell
vLeadWriteDate = now
Be sure the column is wide enough or you will see ########. "Eric" wrote: Hello, I am looking for a line of code that I could add to the end of my macro that would insert the date and time the macro was first run into a cell named "vLeadWriteDate". Any help would be great. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Date and time in Cell
If you only want the first occurance, then
If vLeadWriteDate "" The 'Do nothing Else vLeadWriteDate = now End If "Eric" wrote: Hello, I am looking for a line of code that I could add to the end of my macro that would insert the date and time the macro was first run into a cell named "vLeadWriteDate". Any help would be great. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Date and time in Cell
I'll get this right pretty soon. This should do it:
If Range("vLeadWriteDate") "" The 'Do nothing Else Range("vLeadWriteDate") = now End If "JLGWhiz" wrote: If you only want the first occurance, then If vLeadWriteDate "" The 'Do nothing Else vLeadWriteDate = now End If "Eric" wrote: Hello, I am looking for a line of code that I could add to the end of my macro that would insert the date and time the macro was first run into a cell named "vLeadWriteDate". Any help would be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto insert Date & Time when another cell is populated | Excel Discussion (Misc queries) | |||
Auto insert date/time | Excel Worksheet Functions | |||
insert date and time picker | Setting up and Configuration of Excel | |||
how do I insert the current time (static) and date in a cell? | Excel Discussion (Misc queries) | |||
Auto date/time insert when data entered into an adjacent cell | Excel Worksheet Functions |