Print issue

[Noz2k]

I have a sheet, which on command button click runs a macro which copies a range, unhides some rows at the bottom and then pastes into these.

That's all fine, except when I go to print the sheet, these new cells don't show up.

Any idea why? or how to rectify this?

 

[VoG]

You probably need to set the print area before printing, for example

ActiveSheet.PageSetup.PrintArea = ActiveSheet.UsedRange.Address

 

[Noz2k]

Thanks VoG, have done something similar to that. Took a bit longer as I coded the specific range after each argument, where more cells are added. But your way looks like I could have just used that at the end procedure to automatically update to the range.


The issue I'm having now is how to place page breaks into the new info? I've tried using code like

ActiveSheet.HPageBreaks.Add Before:=Range("A265")

But that doesn't seem to work


Edit: Yes it does, just the first few new cells where added before I had included that code, so just needed to reset the page.