| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding text to an Activecell
Hi there....Need help!!
I am writing some code whereby once I know which cell is the current ActiveCell, I have to add a timestamp value to the cell which I am getting as follows. Application.ActiveCell.Value = Format(Date) Now my trouble is that this statement is overwriting the existing information in the cell. I want my code to add timestamp either at the top or bottom of existing text in the cell without it deleting any current contents... So if A6 = "Hello World" before..... I want it to look like this after code... A6= 25/10/2007 "Hello World" or "Hello World " 25/10/2007 Hope you can help...Let me know if you need more information... Regards Veeraan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding text to an Activecell
what about
ActiveCell.Value = activecell.value & " " & Format(Date) (application is not needed!) hth Carlo "veeraan" wrote: Hi there....Need help!! I am writing some code whereby once I know which cell is the current ActiveCell, I have to add a timestamp value to the cell which I am getting as follows. Application.ActiveCell.Value = Format(Date) Now my trouble is that this statement is overwriting the existing information in the cell. I want my code to add timestamp either at the top or bottom of existing text in the cell without it deleting any current contents... So if A6 = "Hello World" before..... I want it to look like this after code... A6= 25/10/2007 "Hello World" or "Hello World " 25/10/2007 Hope you can help...Let me know if you need more information... Regards Veeraan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding text to an Activecell
Thanks Carlo...that helps
"Carlo" wrote: what about ActiveCell.Value = activecell.value & " " & Format(Date) (application is not needed!) hth Carlo "veeraan" wrote: Hi there....Need help!! I am writing some code whereby once I know which cell is the current ActiveCell, I have to add a timestamp value to the cell which I am getting as follows. Application.ActiveCell.Value = Format(Date) Now my trouble is that this statement is overwriting the existing information in the cell. I want my code to add timestamp either at the top or bottom of existing text in the cell without it deleting any current contents... So if A6 = "Hello World" before..... I want it to look like this after code... A6= 25/10/2007 "Hello World" or "Hello World " 25/10/2007 Hope you can help...Let me know if you need more information... Regards Veeraan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Echo Contents of ActiveCell into a Text box. | Excel Discussion (Misc queries) | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| Still having issues with adding a period to a ActiveCell.Value | Excel Programming | |||
| How do I insert Text Box in ActiveCell | Excel Programming | |||
| If activecell is not text | Excel Programming | |||
Linear Mode
