Hide columns with 0 in a specific cell

Hello.

First of all thank you very much for this forum, it is excelent!

I have an excel sheet where I have to hide columns of a specific range when the value of a specific cell in that column is 0. The problem is that this macro becomes very slow, moreover if I run it in excel 2007 (I use a normal for - next macro).

I have seen that there is a macro by the user watersev in another thread that is awesome. This is the thread:

http://www.excelforum.com/excel-prog...ell-value.html

The problem is that my excel skills are not that professional to modify it. What I exactly need is:

I need to hide columns in a specific range from column G to column BD.
In the row number 6 I have numbers
If the number in this cell is 0 the column has to be hidden

Can somebody help me?

Thank you in advance,

Manolo

hi Poldark, please check attachment

Hi watersev.

Thank you very much! it works perfectly

Regards from Spain

thank you

if the solution offered takes care of your needs, please mark the thread as Solved:

If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.