I'm looping through a number of reports, and the print area is going to vary, depending on how many columns of data I have present. The starting cell will always be A1, but sometimes the print area will end at D1, E1, F1, etc.
Is there a way to use VBA to set the print area for each report, by refering to a worksheet containing the correct # of columns of data present.
In worksheet "Count," cell A1 = 3. This would mean the print area of my report would be A1 to (A1+3).
Is there a way to use VBA to set the print area for each report, by refering to a worksheet containing the correct # of columns of data present.
In worksheet "Count," cell A1 = 3. This would mean the print area of my report would be A1 to (A1+3).