I am new to Excel and VBA. I am trying to hide rows based on whether the user enters a specific word(s)/phrase into a specific cell. For example, if cell M49 has a value of "i love lucy", then unhide rows 50 through 55, if cell M49 is empty or has any other value than "i love lucy", then hide the rows. How do I implement that? So if you guys have any information or any ideas for this then please let me know.
Bookmarks