| Home |
| Search |
| Today's Posts |
|
#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 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically insert system time in a cell | Excel Discussion (Misc queries) | |||
| How do I automatically pull a new invoice number into an excel te. | Excel Discussion (Misc queries) | |||
| read number/currency automatically | Excel Discussion (Misc queries) | |||
| Auto Calculation Automatically Turns Off???? | Excel Discussion (Misc queries) | |||
| prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
Threaded Mode
