Hi All,

I have written a macro and attached same to a control button which will
simply copy the value in WB1, open WB2 and paste the value.

The value from WB1 is contained in merged cells. Could someone assist me
with code that will copy and paste only the value contained in the merged
cells.

--
Thanks

Ron