VBA question - refreshing a cell

[robjhall]

Hi all,

Apologies for my incorrect language on some of my terms but I'm very much a VBA newbie.

I currently have a macro which hides columns depending on the result of a cell. i.e. If cell A1=A then hide columns C:D and if A1=B then hide columns E:F.

It works perfectly fine however the result in cell A1 comes from another sheet which is populated via a validation drop down, now when this is changed (and it subsequently changes cell A1) the sheet doesn't automatically then run the macro to hide the columns.

Any ideas?

Thanks

 

[Fluff]

Is your macro a worksheet change event?

 

[robjhall]

Yes it is

 

[Fluff]

In that case you can move it to the sheet with the dropdown & qualify the columns/ranges to be hidden with the sheet name.

 

[robjhall]

So instead of having the macro in the sheet where I want the columns hiding I change this to the sheet with the drop down in and reference to the other sheet which has the columns I want hiding?

 

[Fluff]

That's right.