Macro to copy and paste into consecutive rows

Hi All,

Thanks in advance! I would like a macro which will copy range $A$1:$Z$1 and paste it as values into AA1:ZZ1.

Easy enough on the first run; but on the second, copy the same range $A$1:$Z$1 and paste it as values into AA2:ZZ2

third run into AA3:ZZ3, etc.

I don't think you mean AA:ZZ. I think you mean AA:AZ. If I am wrong let me know:

Please Login or Register  to view this content.

Yes, thank you! You are right AA:AZ - and it works perfectly!

983 2014-08-05.jpg