Register
Log In
Unanswered
Home
August 25, 2017
Offline
I have a macro and received error message, cannot change part of a merged cell. Can someone tell me what I am doing wrong and what is the solution.
Here is my macro
Dim myArray (0 to 1000) As Variant
Workbooks("MGN-JULY 2017_Final Report").Worksheets(Sheet2").Range("J94:L94").Copy Destination:=Workbooks("MGN_SortMacro_JULY 2017").Worksheets ("TEST H2").Range("E5:P5")
End Sub
Columns E5:P5 are merged.
Thanks
See Answer
Members
Dashboards
Power Query
Power Pivot
Power BI
December 7, 2016
Offline
Hello,
I am just a basic user of VBA, but I will try to give some help anyway.
What first strikes me is that your range where you copy the data from is three cells, J94, K94 and L94. But the range where you want to paste it in is scripted to be a range of 12 cells. That is probably the main reason to your issue, the merged cells.
In this forum I found that when the user used xlPasteValuesAndNumberFormats it worked fine to paste the values to merged cells. Do test to use the PasteSpecial method. I am also linking to a useful site where you can read more about using PasteSpecial.
Best of luck!
Br,
Anders
Answers Post
Most Users Ever Online: 57
Currently Online:
12 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Mohamed Rehan Memon
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
