I have a print range Named Inventory $B$2: $K$9
In Cell K1 I have the variable row I want to be the bottom right of the print range.
I would like to be able to insert, the last row in the print range, into Cell K1
It would then replace the last row($K$9) in the Inventory range
If I put 30 into K1, it would change the print range to $B$2: $K$30
This being said, I can quickly and easily change the range I want to print.