Help needed with VBA code

[PGD15]

Hi,

I am currently looking to write some VBA code to say if a certain cell equals a certain value then hide a row otherwise this row should be displayed.

E.g. If cell value L92 is populated with the value Yes, then I want rows 95 & 96 to be on show. If L92 is blank/empty or filled with any value other than yes (<> yes) then i want rows 95 & 66 to be hidden. (I know its possible to change the row heights accordingly but I do not know how).

If you are able to help by posting the code, can you please include 'explaining what each part means Thanks!

 

[PGD15]

Hi, Yeah that worked perfectly thanks Rory! makes sense once i see it thanks for all the help.

 

[RoryA]

Glad to help.