Hiding Columns with VBA

[Lonergan]

Hello. I have a situation where depending on the values of a matrix of cells in a first sheet, certain columns in the rest of the sheets (probably 5 more) will either be hidden or visible. I'm sure it's possible but I'm not familiar enough with VBA syntax to make it happen...

Any suggestions?

PS... i also need the macro to run everytime a cell in the first sheet is changed.

Thanks.

[StephenR]

Perhaps you can attach a sample workbook illustrating how your data are arranged?

[mudraker]

PS... i also need the macro to run everytime a cell in the first sheet is changed.

Do you already have the macro that needs to run?

If not & you need assistance with it then you will need to supply a lot more details

changes to what cell/s is required to trigger the cell


Extract from forum rules

3). Ensure Your question is not too vague. Never assume anyone is familiar with your problem. While you can upload/download small attachments you MUST ALWAYS FULLY DESCRIBE YOUR PROBLEM IN THE POST TEXT. If you cannot be bothered to clearly explain your problem, don't expect anyone to bother helping for free. While the person helping may be a true Guru, however, in regards to your problem, he/she can only know what you tell them.

4). Ensure your question is not too detailed and does not contain irrelevant details. Please be as descriptive, concise and to-the-point as possible. Short, direct & to-the-point questions with apt Thread Titles are ALWAYS answered quickly.