cdevlinrushe
New Member
- Joined
- Dec 10, 2015
- Messages
- 4
Hi All,
I need to use VBA to 'double click' on my total figure to being up the detail in a new sheet.
I can't record the macro as the cell reference changes.
The column label is Status and the column heading for the total for the Status I want is 'Open'.
The cell I want to double click on his in the calculated Grand Total Row.
Any idea of how I would do this I would really appreciate!
I need to use VBA to 'double click' on my total figure to being up the detail in a new sheet.
I can't record the macro as the cell reference changes.
The column label is Status and the column heading for the total for the Status I want is 'Open'.
The cell I want to double click on his in the calculated Grand Total Row.
Any idea of how I would do this I would really appreciate!