editing recorded VBA code

["Walter Lake" <wlake@xxxxxxxxx>]

Thanks for your email

Using your macro recorder will certainly help to understand VBA code. The
next step is to edit it. Here's a couple of emails from the XL List that are
similar to some advise that I received. It really helped me.

Best regards

Walter

====================================

> Presently when i select  a range to copy, i then
> select
> the sheet and range where i want to paste this too.
>
> Though it works, it's  quite cumbersome, what's a
> better
> way to do it please.
>
> EG Range("a1:B2").Select
> Selection.Copy
> Worksheets("Sheet2").Activate
> Range("A1").Select
> Activesheet.Paste
>
> horrendous i know, that and many other reasons is
> why i want
> a better solution please

==============

> Range("a1:B2").Select
> Selection.Copy
> Worksheets("Sheet2").Activate
> Range("A1").Select
> Activesheet.Paste

Range("A1:B2").Copy Worksheets("Sheet2").Range("A1")

Never use the Select and Activate Methods if you don't have to.
Cumbersomeness
is the least of your worries. Good luck!