Print worksheet

[tapsmiled]

Hi,
I have a Command Button to print a worksheet. On that worksheet, there are potentially several hundred rows of data in A:M. The rows are only filled under certain circumstances, but the formula to populate them has been copied down the sheet to infinity. When I try to print the sheet, it wants to print cells that are blank but have a formula contained in them. Does anyone know how I can only print those cells that contain text and not the ones that are blank and only contain formulas?

Thank you!

[jewelsharma]

you can specify the range to print using

Please Login or Register  to view this content.

search this forum or google for examples.
Good luck

[tapsmiled]

Thanks for the help. The print area will be undefined though. Each month may have a different number of occupied cells, and the end-users for this will not know how to search or filter for this.

[jewelsharma]

Mate, try to set the print area conditionally based on the last occupied cell. Something like this:

Please Login or Register  to view this content.

HTH!

[tapsmiled]

Thanks. I added the command, and it froze everything up for a few seconds and nothing printed. Here's the workbook as it is now.

[jewelsharma]

Mate, I was hoping that you will replace the following part of the code with the printout code:

Please Login or Register  to view this content.

Nevermind, try this instead:

Please Login or Register  to view this content.

Also see attached - Teletype Form 3.xlsm
HTH!

[tapsmiled]

Sorry man. Thanks. I will give it a go when I return to work tomorrow. Thank you!

[tapsmiled]

Worked like a charm!!!! For your code, if the user inadvertently hits the button to print and the ComboBox is still blank, how could I prevent unnecessary copies? Since this is triggering an auto-print, I also don't want the user to print the last report...only the one currently being requested.

[jewelsharma]

To prevent inadvertent printing see attached - Teletype Form 3.xlsm
I'm not really sure by what is implied by

I also don't want the user to print the last report...only the one currently being requested.

Please exemplify.

[tapsmiled]

If the user accidentally hits the Print button rather than the submit, it will reprint the last month requested since that information still appears on the sheet.

Can it be altered to a Print Preview so that only certain pages can be printed? The document could be extremely long depending upon how much was done during the month.

[cemregunay]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[tapsmiled]

Please Login or Register  to view this content.

My apologies, I posted an earlier version of the code. At the top you will see my failed attempt to get it to work. Apparently, I'm missing Do