Conditionally hiding columns in Excel using VBA

**MrV** · 01-10-2012, 08:55 AM

I am trying to hide columns when the value in a row is greater than value in a specfic cell. I modified code that I found on the forum to achieve this but somehow just can get it to fire. As I change the value in the specified cell all columns remain visible. The code I modified is shown below and comes from the following post.

http://www.excelforum.com/excel-prog...ll-result.html

I am a bit of a newbie at this but can generally follow what's going on in the code... the Dummies book helped a bunch!

Please Login or Register  to view this content.

Thanks very much for your help!

--MrV

**nilem** · 01-10-2012, 09:02 AM

try it

Please Login or Register  to view this content.

**MrV** · 01-13-2012, 05:30 PM

Thanks very much for the suggestion. Unfortunately, it still does not fire. I have attached a copy of the file for your reference.

Just to make sure I am understanding this correctly, the appropriate columns should disappear when I change the value in B3.

Your help is appreciated!

--MrV

2012 QTD Forecast Tracking.xlsm