Hiding Multiple Columns based on Cell Value

Hi All,

I am trying to hide columns in a range of data to get around the problem of my chart showing 8 potential lines on a line chart rather than 2-3 (depending on the data available).

I have done some searching and this code works for me to hide a single column:

Please Login or Register  to view this content.

However, i'd like to also apply this to Column G when "C4" is 0, and Column H when "D4" is 0 etc.

I tried to just copy and paste the code and make the changes but it wont allow me. I am using the code in the command window of the sheet so that Excel auto-calculates it each time, this way my chart will be dynamic on the screen.

Can anyone suggest how I go about this? - I am not too familiar with VBA but trying to get onto a course (when it comes to loops and EndIfs etc, I get easily confused!)

Thanks,
Simon

Please use Code Tags:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Please Login or Register  to view this content.

Regards, TMS

noted and edited my original post.

Thanks, appreciated

Hi,

Maybe the following

Please Login or Register  to view this content.