Husker87:
try , PasteSpecial method
Worksheets("Sheet1").Range("A1:D10").Copy
Worksheets("Sheet2").Range("A1").PasteSpecial Paste:=xlPasteValues
--
天行健，君*以自強不息
地勢坤，君*以厚德載物
http://www.vba.com.tw/plog/
"Husker87" wrote:
I have a macro that copies some data to another worksheet in the workbook.
It copies the data as values only. (Some of the date in the first worksheet
is result of formulas and I just want the data to be copied) Anyway, how can
I run the macro each time the workbook is saved so that the second worksheet
always has update data in it? Any ideas?