I was wondering whether there is a VBA which format multiple cells to contain a line break. What I need is as follows:
I would like all the cells found in column D (of a Sheet 1) to have the following format: a line break (similar to Alt-Enter), text, another line Break (similar to Alt-Enter). Example, cell D1, would look like this:
I would like this format for all cells in column D.
Is there a VBA which makes this possible or any work around?
Thanks a lot everyone