Re: $$Excel-Macros$$ Help on Date Function

2009-12-05 Thread Dilip Pandey
Hi Gopi, The attached workbook has been revised as per your requirements. Now whenever the current user will close the workbook, the date stamp will freeze automatically. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.c

Re: $$Excel-Macros$$ Help on Date Function

2009-12-04 Thread RolfJ
Since I am firm believer in writing concise code whenever possible, especially when assisting others in learning the power of VBA, I thought it would be helpful to post a shorter version of your Move_Only_Date_To_Result routine (3 statements instead of 9): Sub Move_Only_Date_to_Result() Sheets

Re: $$Excel-Macros$$ Help on Date Function

2009-12-03 Thread Aindril De
Use Track Changes option of Excel... On Thu, Dec 3, 2009 at 10:11 PM, krishnan Gopi wrote: > Hello All, > > Facing problem with date function, the same is explained in the attachment. > > Regards > Gopi Krishnan > > -- > > -

$$Excel-Macros$$ Help on Date Function

2009-12-03 Thread krishnan Gopi
Hello All, Facing problem with date function, the same is explained in the attachment. Regards Gopi Krishnan -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downl