I am writing a macro that places data from one sheet into a new sheet. Where
or how do I get the instruction move a row or range of data more efficiently
than sheets ("sheet2").range("q15")=sheets("sheet1").range("a1 ")
Thanks for the prod in the right direction
Pat

Sheet 1
a b c d e
1 K L O P
2 L P M N
Sheet 2
Q R S T
15
16