Print only cells with data

[Rockguy667]

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!

[Logit]

I'm not aware of a means to print without using VBA macro, other than the built-in PRINT/PRINT PREVIEW
from Microsoft.

Paste this macro into a routine module, use a command button to activate.

Please Login or Register  to view this content.

[Rockguy667]

Thanks for the reply Logit-
I'm unable to utilize macros due to company policy, and also that end users of the file do not have the ability or knowledge to use macros. I know it's silly, but the file has to work within company policy and procedure.

[Logit]

I understand the company policy.

Re users ... just clicking one button would be the only thing to be done.

Guess you will have to include specific instructions (outside of the designated print area) for the user to follow:

Instructions To Print This Page: blah blah blah about using the MS Print / Print Preview.

[Rockguy667]

Thanks for the advice.
I'm still hoping there's a solution that won't require a complete rework of the file. I'd rather not have to make a submission change to document control.

:/