I have a sheet that reports on data in another worksheet based on
parameters in the third worksheet.

The number of lines on the report worksheet may vary according to the
parameters I put in the third (control) worksheet.

What I want to do is have a macro that will print the report but only
as far as the data is rather that the underlying formulae so I don't
have multiple wasted lines at the bottom.

Can anyone help me to do this please.

Thanks

David