Worksheet_Change Macro To Hide Columns Based On A Range But Only When One Cell Is Edited

[GEANZ]

Hi Forum,

Please find attached an example of what i'm trying to achieve (note this is a small portion of a much larger sheet).

Essentially whenever a 'Y' or a 'N' is entered into a cell the macro would check a range of cells and only hide the columns if no other 'Y' 's are found in the range.

This needs to then be replicated for a couple of ranges within the one worksheet. (see attached)

I guessed the below which does not work:

Please Login or Register  to view this content.

Many thanks in advance.

-Ollie

[tehneXus]

Hi,

this hides the next 2 columns to the right if specified column does not contain any 'Y' or 'y':

Please Login or Register  to view this content.