How do I paste the value instead of the formula at a certain time everyday?
J Jeffro Jan 6, 2005 #2 TM, Right click on cell, go down to paste special, then click on value. That should work. Jeffro
G Gord Dibben Jan 6, 2005 #3 TM "At a certain time every day" would require VBA code using the OnTime method. See Chip Pearson's site if you want to go that route. http://www.cpearson.com/excel/ontime.htm The pasting of the contents as a value could be handled by Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Gord Dibben Excel MVP
TM "At a certain time every day" would require VBA code using the OnTime method. See Chip Pearson's site if you want to go that route. http://www.cpearson.com/excel/ontime.htm The pasting of the contents as a value could be handled by Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Gord Dibben Excel MVP
