Please help to set print area automatically

Solved/Closed

D - Jun 7, 2010 at 10:37 AM
rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

- Jun 7, 2010 at 05:00 PM

Hello,

I have an issue with print areas. I have a worksheet with equations in it up to cell # 5000. However, most of the time, the equations usually only fill up to 1000 or 2000. Is there a way to automatically get the worksheet to print only the cells that are filled in and not the cells that have an equation in them but appear blank?

Thank you so much for any type of solution!

Please help to set print area automatically
How to set up an automatic reply on outlook app - Guide
LibreOffice - Automatically reduce transparency when printing - How-To - Office Software
LibreOffice - Set the default resolution when printing bitmaps i - How-To - Office Software
Set your Telegram account to automatically self-destruct - Guide
How to set and print an A5 page in Word? - Guide

1 reply

Answer 1 / 1

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

770
Jun 7, 2010 at 10:52 AM

You can define the print area in this routine i think
This is the workbook level routine

Private Sub Workbook_BeforePrint(Cancel As Boolean)

End Sub

D
Jun 7, 2010 at 03:35 PM

rizvisa,

Thank you very much for your help, but this doesn't seem to be working. How do I get to the workbook level routine?

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

770
Jun 7, 2010 at 05:00 PM

By Workbook level, what I meant to say was that it is an workbook event, IF you goto VBE, you would have to enter this in ThisWorkbook

Subscribe To Our Newsletter!