Current date
in [General]
|
From: richzip on 3 May 2010 23:43 I apologize if this is posted twice, but the post I made earlier doesn't seem to be showing. I have a macro set up that copies parts of a large worksheet into smaller, individual worksheets. In these individual worksheets, I would also like to place the current date (the date on which these sheets are being generated). I don't want the date to change when someone opens it on a later date, so I don't think the =TODAY() formula would work--correct me if I'm wrong?
From: Jacob Skaria on 4 May 2010 00:06 Within the macro add one more line. The below would add the date to cell A1 of the active sheet Range("A1") = Date -- Jacob (MVP - Excel) "richzip" wrote: > I apologize if this is posted twice, but the post I made earlier doesn't seem > to be showing. > > I have a macro set up that copies parts of a large worksheet into smaller, > individual worksheets. In these individual worksheets, I would also like to > place the current date (the date on which these sheets are being generated). > I don't want the date to change when someone opens it on a later date, so I > don't think the =TODAY() formula would work--correct me if I'm wrong?
From: FSt1 on 4 May 2010 00:08 hi you are not wrong about Today(). it is volitile and keyed to the system clock meaning that it would change to the current date each time the sheet calculates. so in your macro somewhere either before or after the copy/paste, enter a line like this. range("A1").value = Date 'change cell reference to suit your needs. vb recognizes Date as the current date and is not volitile meaning it wont change. regards FSt1 "richzip" wrote: > I apologize if this is posted twice, but the post I made earlier doesn't seem > to be showing. > > I have a macro set up that copies parts of a large worksheet into smaller, > individual worksheets. In these individual worksheets, I would also like to > place the current date (the date on which these sheets are being generated). > I don't want the date to change when someone opens it on a later date, so I > don't think the =TODAY() formula would work--correct me if I'm wrong?
|
Pages: 1 Prev: Keyboard shortcut to select entire column Next: SUMPRODUCT QUESTION?, Ratios |