Change Print Range based on Cell Value

  • 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

    For Example:

    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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!