Past Value automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

"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
 
You must log in or register to reply here.

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

Paste Special Values 2
Copy and Pasting 1
Can a Excel Spreadsheet automaticly open only once a week? 1
copy data from one excel workbook to another workbook using macro 4
Copy & Paste Special Operations 2
Paste Formula 1
VLOOKUP and date issue 1
Paste Special Formula Multiply feature doesn't work anymore 2

Back
Top