Excel offset with merged cells.

[will_maunders]

Hi
Im trying to automate creating a basic report, in the below simplified format. What i want to happen is that every time button 1 is clicked a new row set or rows is added, i.e. next 3 rows are merged for columns a,b,c & d are merged but not for column e.

Would anyone be able to assist with the code to get started with this?

Thanks.
Will

 

[mumps]

You will find that merged cells most often create problems for macros so they should be avoided at all cost. I would suggest that you re-design your sheet to eliminate them. Then
perhaps you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. It is hard to work with a picture. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).