I'm trying to figure out a way to hide a dynamic range of rows when a particular cell becomes active either via a mouse click or cell navigation using the arrow keys. For instance, in cell A1, i have the word "Hide" while the range "Data" is a series of rows that increases or decreases base on how much data there is. What i'd like to have happen is when either the mouse clicks on A1 or the cursor is moved to a1, the "Data" range is hidden and the word "Show" appears in A1. When A1 is clicked again, the "Data" range appears again.
Can anyone help with this as i am just learning macro code...
Can anyone help with this as i am just learning macro code...