I don't often post here, but I have a question. I need an excel macro to run on a change of a cell and unhide the row below that cell based on the results of a formula in that hidden row (happens to be offset).
Essentially I need this.
- Change is made to cell
- Based on results of a cell in the row below, unhide that row
I am unsure how to do this, as I am fairly new to the VBA world. I know I need to attach it to the oncalculate or change event, but I am unsure how to get the current cell that is changing and go from there. Any help would be appreciated.
Essentially I need this.
- Change is made to cell
- Based on results of a cell in the row below, unhide that row
I am unsure how to do this, as I am fairly new to the VBA world. I know I need to attach it to the oncalculate or change event, but I am unsure how to get the current cell that is changing and go from there. Any help would be appreciated.