Re: Print Hidden Dynamic Worksheet
I have made one slight change to the range and it now looks like:
Code
Sub Print_PL()
Application.ScreenUpdating = False
Sheets("Pricing").Visible = True
Sheets("Pricing").PageSetup.PrintArea = "$A$1:$H$" & _
Sheets("Costing").Range("B65536").End(xlUp).Row
Sheets("Pricing").PrintOut
Sheets("Pricing").Visible = True
Application.ScreenUpdating = True
End Sub
As I had discovered that "A" (on costing) is used in another way and what I wanted to look at was actually in "B". I also had ended up keeping the sheet visible, as the end users didn't like not being able to see what they were printing.
I have attached a sample pricing and sample costing to give an idea what what I am attempting to explain. When I go to print, the print range may go to like 34 and give me two pages?? Now I do have in Page setup, to print line $1:$6 on each page (column headers), but there is not content.
Hope I am making sense
Beeker