Print only visible rows and a print to or save as pdf Macro

[rlebeausw]

ok having a problem i am working on a template for a proposal for work. I had to put in enough room to be able to hold 20 boxes that contain information depending how big the project is that were doing. I have a macro for appling a filter which makes it so only the used boxes are shown(plus other info that doesnt get filtered out).
the formula i used to determine if the row needed to be filtered is thisall filter data is in column A)

=IF($M$226=0,"hide row","print")

The macro i used is:

Please Login or Register  to view this content.

Now heres where im stumped i made a macro assigned it to a button for printing.when i print it out now, instead of the visible data it prints out about 10 or so blank pages where the info that was filtered out would be if it where shown in the printout. I used a simple macro to print which is probably part of the problem

Please Login or Register  to view this content.

Id like to have it only print the parts of the worksheet that visible. And possibly a macro for a print to PDF or save as pdf that will allow me to choose where i save and name the file. If possible id like the macro to be able to be assigned to 2 separate buttons. thank you in advance for any and all ur help

ok having a problem i am working on a template for a proposal for work. I had to put in enough room to be able to hold 20 boxes that contain information depending how big the project is that were doing. I have a macro for appling a filter which makes it so only the used boxes are shown(plus other info that doesnt get filtered out).
the formula i used to determine if the row needed to be filtered is thisall filter data is in column A)

=IF($M$226=0,"hide row","print")

The macro i used is:

Please Login or Register  to view this content.

Now heres where im stumped i made a macro assigned it to a button for printing.when i print it out now, instead of the visible data it prints out about 10 or so blank pages where the info that was filtered out would be if it where shown in the printout. I used a simple macro to print which is probably part of the problem

Please Login or Register  to view this content.

Id like to have it only print the parts of the worksheet that visible. And possibly a macro for a print to PDF or save as pdf that will allow me to choose where i save and name the file. If possible id like the macro to be able to be assigned to 2 separate buttons. thank you in advance for any and all ur help