Generate PDF file on two sites

[etaver87]

Please Login or Register  to view this content.

Is it possible to specify that the output on PDF gets separated on to two pages? I am exporting a worksheet to a PDF but because there are so many columns the font size is very small. If I could split the output to two pages that would be fantastic.

In advance many thanks for your help!

I got it so far that it splits the sheet into three pages (with FitToPages) but now I would like that it ignores the entire first row of the sheet when generating the PDF.

Please Login or Register  to view this content.

Above I specified that it exports the range B2:U100 to the PDF. In that way it would ignore the first row (=A). The problem is, that the "Result" sheet has not always the same amount of data and therefore at times it also copies blank cells to the PDF. Is it possible to specify above code so that it ignores the first row (=A) and ONLY copies those rows to the PDF that are filled?

[etaver87]

Anyone with an idea how to tackle this?

[Alf]

Is it possible to specify above code so that it ignores the first row (=A) and ONLY copies those rows to the PDF that are filled?

Yes but it depends a bit on where your blank rows are found. If the range to the last row for U varies but every row from B2 to the last U row say U75 are all non blanks a bit of code like this would find the last row in U column with a value and then you could set the propper range:

Please Login or Register  to view this content.

But it you have blank rows in between B2 and U100 then I would recomend using and autofilter to get rid of the blank rows and use the filtered range (only visible cells) as the range to convert to pdf.

By the way have you tried to make your pdf file after removing these lines from you macro?

Please Login or Register  to view this content.

Alf