Pasting based on Current Region but want spacer row betwen

Hello Everyone!

So I've spent quite a bit of time giving this the old heave-ho but cannot seem to figure out how to do this in a way that doesn't upend everything.

I have the following VBA code (that I somehow managed to cobble together by myself!):

Please Login or Register  to view this content.

And what this code does is copy the range from Column B to Au. There are 8 rows of data and my plus 1 also copies the spacer row (for the formatting) and pastes all this gobbledy-gook into another sheet starting at cell b9.

I have already achieved having the ranges paste one after another but for the sake of aesthetics for the end user, I'd like to add a row between.

The problem is, you guessed it, that that spacer row doesn't count in the currentregion in my second sheet and therefor only two entries get posted (the second just being over-written every time a new range is transferred).

Any idea how to have my cake and eat it too?

Hi Shg,

The first time I tried to run it I received an error of "we can't do that to a merged cell."

Tried removing the (3) (foolishly) and it over-wrote a static portion at the top of the sheet.

Not sure why I received the merged cell error, I can attach the workbook if you think that'll be best?

For any of the fields on the form that require user entry (through userform), I have unmerged cells that are centered across selection. The only merged cells are titles and formula cells.