Copy 2 cells and paste - looping

Hi,

I have code which copies Range("A1") and pastes into Range("c1").Then it loops to copy a2,a3,a4 and pastes in the same cell c1.

I just want to copy a1 and b1 instead of just a1 and paste into cell c1& c2.Then loop to copy a2&b2 till end.

Please Login or Register  to view this content.

This certainly can't be what you mean but that's how I understand it.

Please Login or Register  to view this content.

Please elaborate little more.

If I understood you correctly then you want to loop through two columns A and B from end to start then want to paste value at Column C like A1 value to C1, B1 value to C2, A2 value to C3, B2 value to C4 and so on..

Please correct me if I am wrong.

Regards,

Try this
exactly what you want

Please Login or Register  to view this content.

Thanks Mates,

I am bit late to thank you for all your sincere efforts.Your help really solved my need.

Thanks,

Netaji