VBA Merge columns and format every nth row

epano

New Member
Joined
Jul 20, 2018
Messages
3
Hello, I'd like to ask for help with some vba coding. I have text (of varying lengths), all in column A but only every 8th row. Currently, the text is not wrapped so it extends across several columns. I need to keep those texts within specific columns only (from A to J) but the row height does not matter.

I am trying to create a VBA code that will merge columns A to J, for every 8th row as long as there is text. Once those cells are merged, I would like to format it with wrap text and left alignment. The final thing I would like it to do is adjust the row height so that all text is seen. I've read that auto-adjusting cell size does not work for merged cells.

Would anyone know a way to do this? Many thanks in advance for the help.
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,127,965
Messages
5,627,899
Members
416,281
Latest member
Olawunmi

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