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
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