I'm not having much luck at making the Sheet 2 macro work. I did goof up when I said the changes would be on Sheet 2, Column D. The changes are actually made to Column G (the formula displays text from Column D as a result). I tried changing the code to this (with no results):
If I change a value in Column G and then manually run the HURows macro, it will unhide and hide. I have the HURows macro in Module2 and the Worksheet Change macro in Sheet 2. Here's the code for HURows now:
Any ideas or suggestions? Thanks!