Line break turns to a rectangle symbol when sheet saved as PDF

Question

If I add a vbNewLine, vbCr or vbLf in a cell, and when I convert sheet to a PDF file, either using WorkSheet.SaveAs PdfFile, 17, Worksheet.ExportAsFixedFormat, or manually use Save As or Export they turn into a little rectangle symbol.

enter image description here

How do I avoid this?

Maybe try to Replace those three characters with a " " before to convert. The little square means that the char is not rendered in PDF (so it remains empty) — Matteo NNZ, Apr 07 '15 at 06:55
I have not only 3 characters, i have a lot of them and they changes dinamicly acording on that user selected — Dmitrij Holkin, Apr 07 '15 at 07:00

score 1 · Accepted Answer · answered Apr 07 '15 at 07:12

1

Does this hapens when you trying to add newline as vbCrLf ? Then try use only vbLf

answered Apr 07 '15 at 07:12

score 0 · Answer 2 · answered Jul 27 '21 at 08:47

0

I know it an old trend but for me it worked using vbLf as newline command.

answered Jul 27 '21 at 08:47

Maximiliano Alejandro Bless

1

Line break turns to a rectangle symbol when sheet saved as PDF

2 Answers2