Remove blank rows and print only selected worksheets

Hi MARD99,
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

You can loop through the sheets and set the print areas, then print the sheet.

Your working code would have "PrintOut" instead of "PrintPreview"

Please Login or Register  to view this content.

If you already have the print area set then you can also write a macro to temprarily hide the empty rows before printing and then unhides them again.

The I guess it's time to start learning

Can you attach a file with some dummy data but that does have the page layout like you want it?
I'll write you one macro so you can modify it to your liking (at the same time it will be good training) VBA is really very simple, just a set of instructions that are carried out one after the other.
All it really does is translate your actions to lines of code.

If I have this I want it to do that else do something else, etc.

Originally Posted by MARD99

Thanks for your post. Can you incorporate code to omit the blank rows from printing? I'm trying not to have to set the print area for each sheet.

You have 100 rows of formulas, the code finds the last cell that has a value in it and sets the print area.

@Keebellah- check out the previous posts for the workbook

I missed that one.
I'll incorporate the code

Does this mean that you have set your print area to 99 rows?

Thse are the worksheet's printareas:

Please Login or Register  to view this content.

I assume that you do not want to include the ones colored red

You should have told met that the blank rows all contain formula's

But this works:

Place the code below in ThisWorkBook Project window

Please Login or Register  to view this content.

and this code in a module to invoke after you have printed the page

Please Login or Register  to view this content.

This will unhide the rows again.

You could always write a macro to prompt with worksheet you want to print and at the end add the command unHideRows

Let me know if it works

Can you explain what you did?
Here's the file you posted with the code
You have to run the unhide macro manually AFTER printing