View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luc[_5_] Luc[_5_] is offline
external usenet poster
 
Posts: 1
Default Create an undoable 'paste formula' macro

Hello,
I use the 'Paste Special Formula' functionality very often
and therefore would like to set up a shortcut key. I have
recorded a macro but the BIG issue is that then, I am not
able to undo if I pasted in the wrong place.
I did found a few exemples of 'Undo' VBA macros on the NEt
but none would work with 'Paste Special' as the content of
the clipboard gets cleared when I launch them (and
therefore there is nothing to copy anymore!)
Would anyone be kind enough to provide me with the
complete code for those two macros (Paste Formula and Undo
paste formula)?

Many thanks