Hi,

As Peter mentions the undo part is tricky.
See this article on the subject.
http://www.jkp-ads.com/Articles/UndoWithVBA00.asp

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Steven" wrote in message
...
Can you call the PasteValue Toolbar Icon in a macro to execute.

Bottom line I am trying to Paste Value and still be able to Undo if
needed.

Thank you,

Steven