MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Setting Print Area based on a calculated value in a cell

Posted by Jason on July 13, 2000 11:58 AM

I have a value calculated in a cell (C10), and I would like to dynamically set the print area to be from A1:(Value of C10+1)18. Always printing the first 18 rows, and changing the amount of columns based on the C10 value (incremented by one).

Any ideas?



Posted by Ryan on July 13, 0100 12:15 PM

Here you go Jason,
Hope everything's going good!


Sub SetPrintArea()
ActiveSheet.PageSetup.PrintArea = Range(Cells(1, 1), Cells(18, Range("C10").Value + 1)).Address
End Sub

Posted by Jason on July 13, 0100 12:30 PM

Excellent! Muy bien!