Hi all,
I have a column (L) which prints today()+3 if the the corresponding column (K) is "Yes":
The problem I have is, when tomorrow comes, the +3 still remains live and so, it adds another day onto the date.
Please Login or Register to view this content.
What I need is, some sort of 'Before saving the worksheet' for the macro to convert any dates on there into text. Within L5:L36665
Any help would be hugely appreciated.Please Login or Register to view this content.
Kind Regards,
Last edited by phish3rz; 12-10-2012 at 12:03 PM. Reason: Solved!
Please Login or Register to view this content.
Hi Legend Rubber, thank you for your reply. I've added this however, the formula is still there after I save the document. Macros are enabled as well. If you could help shed some light as to why it's not working I'd appreciate it.
Last edited by phish3rz; 12-10-2012 at 11:31 AM. Reason: spelling.
can you attach your worksheet?
To keep the formulas that have not already produced a date, try this code
You cannot have it keep the formula and keep the date within the same cell, if that is what you are asking.Please Login or Register to view this content.
Edit: Opps, fixed code above
Last edited by ChemistB; 12-10-2012 at 11:47 AM. Reason: Corrected code, removed "Selection"
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
@phish3rz
That Code needs to go in the Workbook, not Module1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks