Multiple Worksheet_Change macros in one worksheet

[mallan]

Hi excel gurus

Requesting your help

I need a code automatically to hide rows in the range 97:110 when the cell value in A6 is selected BB or FFF or MM or PP and automatically to unhide the rows when the data in A6 is other than BB or FFF or MM or PP .

The second code I need is to automatically hide rows in the range 47:75 when the cell value in A6 is selected LL or FFF or NN or SS and automatically to unhide the rows when the data in A6 is other than LL or FFF or NN or SS.

Please note on both occasions we have FFF which required to hide different rows that means when I select FFF, I need to hide both rows range 47:75 and also 97:110

I think the workbook is the 2016 version but I want the code for the 2010 version.(I use 2016 at my home and when I saved the 2010 work version in my home computer, it automatically saved as 2016)


Thanks guys

[Bernie Deitrick]

There are no code changes between 2010 and 2016, or workbook differences. There are different functions and utilities available, but that doesn't affect the workbook necessarily.

Your code does what you want (though for different values) - I would just check the cell being changed first to prevent it from being run every time something changes:

Please Login or Register  to view this content.

If you really want to do it for BB or FFF or MM or PP / LL or FFF or NN or SS then just change to those values:

Please Login or Register  to view this content.

[mallan]

Thanks heaps Bernie

Its working