View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default How to undo ClearContents?

Currently, I do Range(...).ClearContents. Apparently, that cannot be
undone by ctrl-Z in Excel.

Is there any way to accomplish the same thing (in VB) so that it can
be undone by ctrl-Z in Excel?