Help with VBA to adjust page break over on column

[taylorsm]

Can we add something that would make the page break at the end of column C? and to set the page break to stop at the last filled row?

Please Login or Register  to view this content.

Edit** Adjusted code to do page break, but when I save as a PDF I get hundreds of blank pages after my data.

Please Login or Register  to view this content.

[jolivanes]

I must be missing something.
Is there a reason why you can't set the print area to what you indicate in your post?
Something along the lines of

Please Login or Register  to view this content.

[taylorsm]

Not missing anything! I had help with the other macro, other than the edit part which i figured out.

The sheet i begin with looks like the example, except it has 240 duplicates that vary in length. Would work for those too?

[jolivanes]

The only hard coded cell reference is cell A1 (Cells(1, 1)) and Column C (Cells(lr, 3)). The 3 here is Column C.
The last cell is lr and could be anything.
If I read it right and you want to export multiple sheets with varying column lengths, you have to let us know because that will change the code in Post #2.

[taylorsm]

If I highlight all the rows below my text and right click/delete then it fixes everything. Can I add something to my VBA that will do this?

[taylorsm]

So I adjusted the example and duplicated it. It would look something like this, but have 240 different accounts.

Sorry, I am re-reading and maybe screwed up a little on the explanation. The example is what my code produces, I start off with something far more complicated, then run this VBA and then my last example workbook is what I end up with. I then have ANOTHER vba that I run and splits my example into three separate worksheets like my original example. So maybe this code isn't the best one to adjust, maybe I need it for the one that actually splits the notepads?

[taylorsm]

This is pretty close to what I use, couple minor adjustments, but I am not on my work computer with the latest version. Does any of this stand out?

Please Login or Register  to view this content.

[jolivanes]

What is your end goal?
From Book2 export Range A1:C12 to PDF, Range A13:C36 To PDF and A37:C51 to PDF?

[jolivanes]

See attached. Is this what you have in mind?
Explanation is in the workbook.

[jolivanes]

You could try this also.
Tailored for your Book2 example only

Please Login or Register  to view this content.