Copy Merged Cells' Values To Clipboard

[Fermented Reptile]

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

[jolivanes]

I read what you said but get rid of the merged Cells. They are an accident waiting to happen.

Please Login or Register  to view this content.