View Single Post
  #6   Report Post  
George Gee
 
Posts: n/a
Default

Andy

Thanks for that, have replaced as you have indicated, and it does run more
smoothly!

As I said, this macro was *recorded*, something even *I* can do!
Editing is another matter!

Thanks again.

George Gee


*Andy Brown* has posted this message:

"George Gee" wrote in message
...
I suppose it would help if I included the macro!

Range("A5:G5").Select
Selection.Insert Shift:=xlDown
Range("B3:F3").Select
Selection.Copy


For efficiency, you should take out as much physical selection as
poss. Forex, replace the last 2 lines with:

Range("B3:F3").Copy

Rgds,
Andy