VBA to jump to range in contained in a SUMIFS formula

[Silverjman]

Hello,


Once you unchecked "Edit in Cell" in options the double click jump to the sum range in the first part of the SUMIFS function is FANTASTIC for transparency, but what if for calculation speed reasons you need to put IFs in front of the SUMIFS instead of Booleans at the back?


You lose the Ctrl { jump as well as the double click jump.


I have had a really tough time Googling this because the keywords involved create a lot of noise. If anyone has failsafe keywords or the first bit of this code I would be very grateful.

How does one suck the Target Range into VBA out of a formula?


In a perfect world I would end up with code that not only BeforeDoubleClick event jumps to the right sum_range but to the group dictated by the IFs in a SUMIFS.


As I said I realise this is a genius level query, so even the smallest amount of help would be appreciated.


Thanks

 

[svendiamond]

What do you mean by the BeforeDoubleClick event "jumps to the right sum_range" or "to the group dictated by the IFs in a SUMIFs" ?

Can you give an example of what exactly you want to happen when you double-click on a particular cell?

 

[Silverjman]

!!!!!!!!!!!!!!
http://www.mrexcel.com/forum/excel-questions/616156-drilling-down-into-sumifs-formula.html