Hide columns based on cell value

[JBM91]

Hi experts,

So I have the following code, which, ideally, should hide columns (range I1:ABJ1) if their value is lower than what is specified in cell G15.
However, when I try to run it, it will not hide any columns at all. Can any of you guys spot why that might be? And do you have an idea of how I can fix it?

Please Login or Register  to view this content.

[WideBoyDixon]

This line:

Please Login or Register  to view this content.

When Target has not been passed or set. Try putting this:

Please Login or Register  to view this content.

Before your macro code and then try compiling if from the Debug menu. You'll get errors that you can correct. For now I've had a go at adapting your macro:

Please Login or Register  to view this content.

WBD

[JBM91]

Thanks WBD!

The code you provided works like an absolute charm - much appreciated!
Is it because I'm using a "standard"-module for this particular coding that the

Please Login or Register  to view this content.

part didn't work? Because I'm using it on a Worksheet_change module where it works fine :o

Thank you so much for your help.

[WideBoyDixon]

The Worksheet_Change macro is automatically passed the Target variable so it's already defined as the range that has changed. Your code didn't have Target passed or defined.

WBD