merged cells copy paste

  1. A

    Automatic way to insert title rows to merged worksheet

    I need to insert title rows repeatedly at regular interval say once in 18 count to the below workbook which has merged cells (Merged cells are, AB, CDE, FGH, IJK, L to AL, AMAN ,AOAQ,AR TO AX The title rows are kindly just me any automatic method to insert this title rows since it is...
  2. S

    Copy Formula that skips cells

    I have a formula that adds together 5 cells that are merged with another 5 cells that are merged and then copy that formula down. so, in Cell A4 through A7 are merged and B4 through B7 are merged. The formula I have looks like this, =SUM(A4+B4) and that formula works, however when I try to...
  3. C

    Copy Paste Failure with Merged Cells

    I have a series of Excel 2003 workbooks on a server. Each workbook contains numerous sheets with a lot of merged cells. Everyday managers run a macro on this workbook which copies selected sheets and places copies in designated folders. This code has worked great for almost 2 years, but now we...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top