Sandy Radjenovic
Board Regular
- Joined
- Nov 4, 2003
- Messages
- 76
Via VBA, I am cutting and pasting a row from the current worksheet to a "done" worksheet which lists all jobs done. This "DONE" worksheet is eventually exported to a dbf.
I would like to update a cell in the "done" worksheet to be that of today's date to reflect date of transfer. Unfortunately, the column I have to work with is a formatted text column. Is there a way to convert a date (i.e. now() ) to a string?
Your help would be appreciated!
I would like to update a cell in the "done" worksheet to be that of today's date to reflect date of transfer. Unfortunately, the column I have to work with is a formatted text column. Is there a way to convert a date (i.e. now() ) to a string?
Your help would be appreciated!