I currently have a table like this.
|This is to demonstrate what i want | | | | |
to do
I have rows like the above each | being a new cell.
I want the marco to:
1. Merge those 5 cells into 1.
2. Left align the text and enable wordwrap.
3. Resize the new merged cell to fit the text. - This is because merged cells do not automatically resize when they go over more than 1 line.
I want it to do this to the whole table. Except for the Header row of course.
|This is to demonstrate what i want | | | | |
to do
I have rows like the above each | being a new cell.
I want the marco to:
1. Merge those 5 cells into 1.
2. Left align the text and enable wordwrap.
3. Resize the new merged cell to fit the text. - This is because merged cells do not automatically resize when they go over more than 1 line.
I want it to do this to the whole table. Except for the Header row of course.