Issues with printing to PDF

I have attached a small Excel sheet and a PDF printout of it. Is there a way to setup my Excel sheets such that when they are going to exported into PDF that they show up the same way. By that I mean when I look at the wrapping text in rows of an Excel sheet, all the text can be seen yet when I export to PDF many times the text is cut off or even rows are missing at the bottom of the wrapped text. You can see what I mean in the PDF example of the Excel sheet both of which are attached.

Thanks in advance,
RR

Sorry I missed a step.

Enlarge the height of the last row in each section that has data.

What I normally do is to add an extra line (Ctrl+Enter) to the last row.

Alt+Enter, not Ctrl+Enter.

Logit, Not every language version will work properly with your code. Some versions have localized Boolean values. Therefore, do not use this construction:

Please Login or Register  to view this content.

E.g. in Norway, using your code, cancelling the window would return “Usann”, so comparing “Usann” <> “False” will allow you to export the file, which of course will end in an error.
Rather, you should aim for this appearance:

Please Login or Register  to view this content.

The GetSaveAsFilename method returns a Variant type. If the window was canceled, it returns a Boolean value False, if the user made a file selection, the return value is of type String.
I quite often use such, at first glance, non-obvious construction.

Please Login or Register  to view this content.

You have to think a little about what the “poet” had in mind.

aresquare1, You can also try this code, which I think gives more manipulation possibilities than just adding a new line.

Please Login or Register  to view this content.

Artik

Artik : Thanks for the input !

Thank you Artik but could you please explain what the macro code is doing in you last example. While I don't have a problem using a macro, but I don't understand what this one is doing.