View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
SteveDB1 SteveDB1 is offline
external usenet poster
 
Posts: 414
Default copy paste methods.....

Mike,
Thanks for the quick response.

The error that I get is a 1004, "Paste Method of worksheet class failed"

as mentioned-- I've tried a number of different types of pasting, and none
of them are working. Which is weird, because they've worked in the past with
other macros.



"Mike H." wrote:

'Select your range then do this:
Selection.Copy

'then go to where you wish to paste and do this:
ActiveSheet.Paste

HTH