I have a situation where I need to have rows hide if a certain value is present in a particular cell.

if A96="N/A" DIM rows 97 - 100

This seems simple but I am clueless with macros. Does anyone have any suggestions?