Re: $$Excel-Macros$$ Need to add date and time to 2 seperate cells

2010-02-26 Thread Christopher Luka
ctual need. > Here's the syntax for putting time or date into a cell using VBA > Range("A1") = Date > Range("B1") = Time > If you want them to insert automatically, you'll have to let us know the > conditions. > Regards - Dave. > > > Date: T

RE: $$Excel-Macros$$ Need to add date and time to 2 seperate cells

2010-02-25 Thread Dave Bonallack
: Thu, 25 Feb 2010 16:11:41 -0800 > Subject: $$Excel-Macros$$ Need to add date and time to 2 seperate cells > From: billypat...@sbcglobal.net > To: excel-macros@googlegroups.com > > I just got a new job after a years layoff. By trade I'm a unix person > but have now entered t

$$Excel-Macros$$ Need to add date and time to 2 seperate cells

2010-02-25 Thread billy patton
I just got a new job after a years layoff. By trade I'm a unix person but have now entered the microsoft world. I'm currently having to d a lot of work in excel. One thing I consistantly have to do is to put the current time into 1 cell and the date into another cell. This has to be an easy func