Complete n0ob here,

I'm trying to write a macro that will copy a sheet from a worksheet into an
archive sheet (it's basically a History file of my orders to suppliers). One
cell has the current date (=TODAY) and when copied it copies the function,
completley ruining the whole idea of archiving. How can I change that cell
to the date I saved the file instead of updating everytime I open the
history file ?

I hope I'm understandable, and Thanx a bunch for the help.

Dr Fleau

Just change A1 to the cell that has your date, and this macro will copy/paste
special value:

Range("A1").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues

--
Kevin Backmann


"Dr Fleau" wrote:

Complete n0ob here,

I'm trying to write a macro that will copy a sheet from a worksheet into an
archive sheet (it's basically a History file of my orders to suppliers). One
cell has the current date (=TODAY) and when copied it copies the function,
completley ruining the whole idea of archiving. How can I change that cell
to the date I saved the file instead of updating everytime I open the
history file ?

I hope I'm understandable, and Thanx a bunch for the help.

Dr Fleau

Beauty. Thanks a lot. Works like a charm.

Dr Fleau


"Kevin B" a écrit dans le message de
news: ...
Just change A1 to the cell that has your date, and this macro will
copy/paste
special value:

Range("A1").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues

--
Kevin Backmann