Date macro

  • Thread starter Thread starter Dr Fleau
  • Start date Start date
D

Dr Fleau

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quick question 3
change =NOW() to permanent date string 4
Macro will copy formula instead of value 6
Loop doens't work properly (Error Handling) 0
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Move Range with a date to a Matching Monthly Worksheet 5
Dynamic Offset from an Application.Goto cell = Date or Time 10
track row changes with date and time stamp 5

Back
Top