Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and paste versus copy and insert copied cells | New Users to Excel | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
How to search column, copy row, and copy to another sheet in same | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel |