Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
I am very sorry about your issues. Can you please attach the XLSM (macro-enabled) file here? You can use the paper clip icon to attach it. Or you can upload it to http://filesXpress.com and give me the short download link.
Please let me know by replying to me here so that I can help you further.
Thank you for the link. Please give me a moment to download and check the file.
I got your file and the printing worked. What specifically you want in the printing? You mentioned about NOT printing the rows with 0s. What specific columns with 0s are you trying to NOT include in the printing?
I printed in PDF, and here is the printout file. Is this printout correct?
Here is the link:
Thank you for that confirmation.
If that is the correct printout, then that is printed using the blue PRINT button in the sheet named "New_Assmbly_Sheet", and NOT from the File => Print dialog box.
Also, please check your print area settings on your Excel to ensure that the print process is not restricted by your print area settings. Then try printing using the blue PRINT button on the sheet.
Keep me posted.