Please fix this macro

[Sarangsood]

I want to copy paste different values of a row just below the last active cell . My macro is :

Please Login or Register  to view this content.

It's not working. I want to copy paste the following range values only ("a21:e22", "ad21:ah22", "bg21:bk22", "cj21:cn22", "dm21:dq2", "ep21:et22", "fs21:fw22", "gb21:gz22", "fy21:ic22", "jb21:jf22") of my worksheet "MC1".

[patel45]

attach please a sample file with data and desired result

[shg]

At a glance,

Please Login or Register  to view this content.

[Sarangsood]

@shg : lol it worked

thanks

[shg]

You're welcome.