Help cleaning up code.

[dcgrove]

Hello, I recorded the code below using the macro recorder and need some help cleaning it up and making it work.

My goal is to link cell A2 in the sourcedatafile to cell B2 in the file I run this in. The next step is to autofill the range B2:N2 with the data from the same sourcedatafile, and then continue the autofill in the range B2:N6841. When I run this code, it says that the "operation requires the merged cells to be identically sized" and fails on the highlighted line below. Is there a more efficient way of copying the data from the sourcedatafile to this workbook? If there is I would love to hear your thoughts!

Please Login or Register  to view this content.

[Mad-Mizer]

Hi dcgrove,

I didn't look too deeply into your code but I will say this, merged cells and VBA make for strange companions. If I were you, I would un-merge cells; ever since I started coding VBA, I found I had to stop using merged cells. Give that a go and see how your code responds.

[dcgrove]

That's one of the issues. There are no merged cells in the source workbook or the destination workbook.

Thanks!

[dcgrove]

Anyone have any ideas?

[Mad-Mizer]

You say there aren't merged cells but you originally stated

it says that the "operation requires the merged cells to be identically sized"

I'll admit, I am confused by this. It may be in your best interest to upload a copy of the workbook. There should be no personal or sensitive data in it.