Hi all,

I've created a document that allows users to generate UTM tracking codes for marketing campaigns. It all works great, but I would like to let users click a button and copy the values to the Windows clipboard so they can then paste the values (note: none of the cell formatting, etc) into emails, etc. Because the tracking codes are long the generated URL is in a merged range (C20:L25). I've been able to find VBA to copy and paste single cell values but am struggling with the code to copy the merged range.

Can anyone help?

TIA,

FermentedR