| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy value only
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. -- (please remember to click yes if replies you receive are helpful to you) "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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy value only
Hi Sean,
Thanks, that helps a lot. I am only just starting to write code and your assistance is greatly appreciated. -- Thanks Ron "SeanC UK" wrote: 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. -- (please remember to click yes if replies you receive are helpful to you) "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| copy formulas from a contiguous range to a safe place and copy them back later | Excel Programming | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
| Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming | |||
| How copy format, font, color and border without copy/paste? | Excel Programming | |||
Linear Mode
