View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Billyruben Billyruben is offline
external usenet poster
 
Posts: 13
Default Activesheet.Paste does OK manually between worksheets but not in M

Background: An area containing data is manually hi-lited and designated for
copying into WorkSheet A (W/S-A). W/S-B is the intended destination.

Under the manual mode, the selected area is pasted into W/S-B without a hitch.

The paste process in W/S- B was carried out while a Macro was being recorded.

When the Macro was subsequently Run, it failed at Activesheet.Paste

Question: Why does the process work manually, but not from a Macro?