How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

I have a single EXCEL 2007 sheet that I would like to create

This answer was rated:

I have a single EXCEL 2007 sheet that I would like to create a print macro for

see below
http://www.filesharesite.com/files/201208/1344354719Print_MAcro.xlsx

I want to print ONE SINGLE SHEET that shows only Column C through Column P and Row 1 through Row 106

But i want to HIDE any ROW in the print range IF ALL of the cells in any ROW in Column G through Column P is equal to "0" or is blank.

So for example, in the sheet attached, Rows 10,17,23,24,27,45,46,47,50,51 ...and any other row with all zeros should be HIDDEN and not print

Hello again

 

I can work on this a bit later on the day unless you want it more urgently than that. Let me know

 

 

Customer: replied 5 years ago.
LAter today is ok. Sounds good.

Thanks

 

Ok here you go

 

http://www.filesharesite.com/files/201208/1344377666Print_MAcro_1.xlsm

 

Click the Go! button on top to run the macro

 

Hope this is ok. Let me know if it needs any tweaking or if you have any questions

 

Thank you for rating this answer "Excellent" or "Good"

 

 

 

John D and 2 other Microsoft Office Specialists are ready to help you