Worksheet Change and Hidden/Unhidden rows

Hello All,

I am putting the finishing touches on a project and I want to hide unnecessary data based on the input of two cells.

I want to search "F5" for the letters "LCL". If found, hide a certain set of rows. If not, move to the next statement. I also want to clear the contents of column M should there be any change initiated by the macro. The second set of code would also be looking at cell "F13" to make sure that it is blank. I am not sure if you can do that in a worksheet change macro.

Currently when I change the value in "F5", the desired rows for that block of code are hidden/unhidden, but the contents of column M are not cleared. I also receive a runtime '1004' - cannot change a merged cell error. If I then try to select a value that does not contain the InStr term "LCL", no action occurs.

Please take a look at the code and let me know what you think.

Thank you!

Please Login or Register  to view this content.