Copy value only

R

ron mann

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.
 
S

SeanC UK

Hi Ron,

I presume that it is currently copying the merged cell format too?

If this is what you are trying to avoid then try using Paste Special (I have
assumed here that you have already selected the WB1 data and copied it):

Range("A1").PasteSpecial Paste:=xlPasteValues

If this is not what you are looking for then please explain the problems you
are having with your code in detail.

Hope this helps,

Sean.
 
R

ron mann

Hi Sean,

Thanks, that helps a lot. I am only just starting to write code and your
assistance is greatly appreciated.
 
Top