Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |