Afternoon
I am looking to export a number of ranges to one single PDF but one of the ranges is a variable range. The ranges I want to export are:
A1:C12
A13:C26
A27:C38
A42:C72
A73:C95
G161: the last cell with a text in it located in Column K
the file name is: thisworkbook.path & “Reports” & “\” & TextBox8.Text
If possible I would be looking to export the first 5 ranges as portrait and the last variable range in Landscape
If anyone can help that would be great
I am looking to export a number of ranges to one single PDF but one of the ranges is a variable range. The ranges I want to export are:
A1:C12
A13:C26
A27:C38
A42:C72
A73:C95
G161: the last cell with a text in it located in Column K
the file name is: thisworkbook.path & “Reports” & “\” & TextBox8.Text
If possible I would be looking to export the first 5 ranges as portrait and the last variable range in Landscape
If anyone can help that would be great