Cut & Paste Selected Row(s)

[backyardfun]

I want to be able to highlight multiple cells in column a in worksheet1 and have that entire row be cut and pasted into the next available row(s) in worksheet2. How can I do that? Thanks!

[stnkynts]

This accomplishes what you asked. If you would like a more specific answer, we would need more specific information:

Please Login or Register  to view this content.

[rscsmith]

If you want to use the current selection, then change the above code to:

Please Login or Register  to view this content.

Cheers, Rob.

[stnkynts]

Hahaha, it's amazing how a different set of eyes see things. I think Rob is on to something. I think when the OP said "Highlight" they actually meant the selected cells. If so then the 1 line should be sufficient. Good eye Rob

Please Login or Register  to view this content.

[backyardfun]

Thanks. The word highlight was a poor choice. You are correct Rob, I did mean select!

[backyardfun]

It works great but I forgot to mention one thing. They are protected cells in the source sheet and I need them to be unprotected when pasted in the destination sheet. What do I need to change? Thanks!

[backyardfun]

I figured it out. Thank you!!