Convert Copy/Paste VBA to Macro without Copy/Paste

I would try this, but not possible to test without your file.

Please Login or Register  to view this content.

I also discourage using ActiveSheet; better to refer directly to desired sheet, unless you can call this macro from different active sheets.

Ahhh awesome thank you kindly! Will test it out now.

It threw me an error "Object variable or With block variable not set. (Happens if I filter out all but one row)

On this line:

Please Login or Register  to view this content.

I guess I forgot to mention, I am copying sorted data, this code copies hidden rows as well, I need to copy only visible rows.

I am not sure what is causing that error. Is it possible for you to attach your file?

The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

That's weird because it is copying everything on the page not just the filtered visible items.
Let me make a sample without all my data in it so I can attach it.

Edit
Okay - attached,(Macro is on the Customer List Tab, last item Mail Merge icon)

BTW the "single item" bug is gone, must have been a typo I had made or something.