View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam via OfficeKB.com Sam via OfficeKB.com is offline
external usenet poster
 
Posts: 247
Default Excel VBA Paste Special - replace contents of destination cells

Hi Jim,

Thank you very much for your assistance: that worked Great!

Cheers
Sam

Jim Cone wrote:
Sam,
You can't reply to it, but you can use the following to prevent
the message from appearing...


Application.DisplayAlerts = False


Set this back to True before exiting the Sub.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200604/1