ExcelBanter - Copy value only

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copy value only (https://www.excelbanter.com/excel-discussion-misc-queries/206207-copy-value-only.html)

ron mann

Copy value only

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

ron mann

Copy value only

I have created this question under Excel programming - please disregard.
--
Thanks

Ron

"ron mann" wrote:

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

All times are GMT +1. The time now is 03:42 AM.