Hello-
I have a workbook that takes information from four of it's worksheets and organizes it into a series of arrays on a fifth sheet. The arrays take up 10 columns, and a few hundred rows. I only want excel to print the actual results of the arrays instead of all the pages. (some of the pages being blank due to the arrays' formulas) The length of the data in the arrays will vary from use to use from one row to the potential end of the array depending on the information entered in the rest of the workbook.
The solution should ideally not be a macro (VBA), and not require printing a selection of cells, or selecting to print only certain pages; i.e. printing should be as simple as clicking print. The sheet being printed will be totally locked from editing from the end user.
Thanks!
Bookmarks