can't Paste Copied Range into individual merged rows cells on another workbook

Hi all, I just finished writing code to copy data from a separate closed Data Worksheet and pasted in the file "Dash Board Shell1" I'm using. I only know how to paste the copied range into rows that are unmerged, like I have done here in my test. Rows A33 and on was pasted data from my code
Screenshot - Dashboard2.jpg

but in reality every 5 rows in my worksheet starting from A3 all the way down will be merged and considered one row, and I want to paste the data I pasted in the first picture (A33 and on) individually in each of the merged cells in column A down
Screenshot - Dashboard.png

Here is the code I have written so far to execute this command, which works:

Please Login or Register  to view this content.

I know somewhere after the Paste Special is where it is possible to write code to paste within merged rows individually but no idea how to do this. If anyone knows I would really appreciate the help as I am getting pretty discouraged. And no I cannot unmerge the rows, they must stay merged because data in further columns if you scroll gets segmented


PS: for privacy reasons I could not upload the actual worksheets sorry, I could only put pictures with black out blurs

Much appreciated!

You need to edit your first post, see below.

Merged cells cause problems, it's best not to use them.

If you are not going to upload your workbook maybe the link below will help.

Center across selection.


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

sorry about that, and I cannot upload the Worksheets like mentioned as it is private for my firm

Why can't you replace confidential information with dummy information?

Real person name with fictitious name, real account number with fictitious account number? You are showing screen shots with a few blacked out cells. If the real sheet is hundreds of rows make a copy delete all but 10 rows or so, whatever it takes to see your issue, and then change the sensitive data. Use the real workbook, we need the structure to be exact as well as sheet names etc.

Originally Posted by lougs7

sorry about that, and I cannot upload the Worksheets like mentioned as it is private for the my firm