Hi all,
I'm trying to create a print macro that would set the print area up to the last value in a specific cell.
For example, in column A, if the last value is in cell A145 then the print area will be A1 to A145.
This method will loop for the next 9 columns (A to J) if they have values.
To clarify, if column A has values up till A145 and column B has values up until B75 then the print area will be set so the first page will print the values in column A till A145 and on the next page it will print column B till cell B75. If there no values in column C and after nothing will be printed.
Thank you in advance!
I'm trying to create a print macro that would set the print area up to the last value in a specific cell.
For example, in column A, if the last value is in cell A145 then the print area will be A1 to A145.
This method will loop for the next 9 columns (A to J) if they have values.
To clarify, if column A has values up till A145 and column B has values up until B75 then the print area will be set so the first page will print the values in column A till A145 and on the next page it will print column B till cell B75. If there no values in column C and after nothing will be printed.
Thank you in advance!