Hi all,
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:

Alt-Enter
text
Alt-Enter.

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

Keibri