Past Value automatically
 

How do I paste the value instead of the formula at a certain time everyday?

TM,

Right click on cell, go down to paste special, then click on value. That
should work.

Jeffro

"TM" wrote:

How do I paste the value instead of the formula at a certain time everyday?

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

On Wed, 5 Jan 2005 16:21:04 -0800, "TM" wrote:

How do I paste the value instead of the formula at a certain time everyday?