Hi,

I want to add extra spacing (one blank line space) should be created after the text. This would allow clean visual effect before the start of the new row.



Is it possible?

In the formula bar hit ALT + Enter that will give you a line break. In VBA type vbcrlf, vbcr or vblf. All will give you a line break.

Or you could simply change the row height, which might make things simpler should you want to use the inserted data.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com