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.
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.