Hi All,
I have had a look around this site for help and found similar posts but nothing exact or that i can get to work. I'm working on Excel 2010 and i want to do the following unhide or hide a value based on a cell value e.g. -
If Cell "C40" = Yes
Unhide Rows 42 - 47
If Cell "C40" = No or BLANK
Hide Rows 42 - 47
Any help would be much appreciated, I assume this needs to be done in VB by right clicking on the sheet>>Show Code then adding it in. Do you just save then and it should work automatically ?
Thank you
I have had a look around this site for help and found similar posts but nothing exact or that i can get to work. I'm working on Excel 2010 and i want to do the following unhide or hide a value based on a cell value e.g. -
If Cell "C40" = Yes
Unhide Rows 42 - 47
If Cell "C40" = No or BLANK
Hide Rows 42 - 47
Any help would be much appreciated, I assume this needs to be done in VB by right clicking on the sheet>>Show Code then adding it in. Do you just save then and it should work automatically ?
Thank you