View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Len Len is offline
external usenet poster
 
Posts: 162
Default Copy Patse Macro

On Jun 20, 3:34*pm, "Snake Plissken"
wrote:
like this, maybe?

* * Sheets("Exp_Grp").Select
* * Range("A1").End(xlDown).Select
* * ActiveCell.Offset(5, 0).Select
* * ActiveSheet.Paste
* * Application.CutCopyMode = False


Hi,

Thanks for prompt reply.
After rectifying the codes based on your suggestion, it still turns
out the same error message at ActiveSheet.Paste ??

Regards
Len