I need a macro that will automatically hide a row when the sum of a row = 0

[rjackson104]

the attached spreadsheet the print range has been set and I would like to create a macro that automatically hides rows that equal zero within that print range (always A1:N138). the rows that need can be hidden are row 6 through 138. the rows shaded in Blue will never be hidden. But if the sum Column A:N equals 0, that row should hide. If we change the number in A4 (a variable) the rows with the new values should be displayed. the macro should also include a print of the page once the macro is completed.

Thanks

[Richard Buttrey]

Hi,

Seems to me that the simplest way is just to filter all non zero value with the single line macro

Please Login or Register  to view this content.

[Leith Ross]

Hello rjackson104,

I have added the macro below to a button at the top of the worksheet to run macro shown below. The button will not print. The attached workbook contains these changes.

Please Login or Register  to view this content.

[rjackson104]

thanks Richard,

This does not seem to work. When running the macro using the criteria, it indicates that it cannot run it in break mode. Which it shouldnt. It also says the command could not be completed by using the range specified. Selct a single cell within the range and try the command again. Only one cell was selected

[rjackson104]

This is awesome, thank you very much

[Richard Buttrey]

Seems to work OK for me. Obviously VBA should not be in Break Mode though.