Macro to hide range of 13 rows if sutotal of range for row 1-13=0 (includes 2 blank rows)

I have been looking for hours for a macro for this and all I find are macros to hide one row at a time. I have a list of 50 unique items with data in columns C thru AI. For each of those in my spreadsheet, the rows are as follows: Row1 is a blank line separating it from the item above. Row 2 is the item number. Rows 3-12 contain data. Row 13 is the subotal for columns S-AI. I need a macro that can look at the subtotal in column AI, the 13th row for each item and if it =0, then hide lines 1-13 for that item. Can this be done?

Hi
Cut and paste this macro into a module in your workbook then run it on your data to test.
This macro is based on the fact that there will be one blank row below each of your subtotals.

Please Login or Register  to view this content.

Hope this helps.
Good luck.
Tony

Thank you AlphaFrog, but I tried the macro and it hid ALL of my rows, even the ones that were not zero.

ARGK (Tony)...The macro works perfectly! You have no idea how you've made my day! Thank you so much!

I appreciate both of your very fast replies!

Thanks for the feedback.
Tony