I'm trying to figure out, how to buld up a VBA smartes to, choose what sheet that should start calculating, based on a targeded rage. (from a list ex. sheet3.cell(3,3) )
I have done this in the macros, with show and hide cells.
Is there a smart way to do this. and if yes. shows i do it in the module, the Workbook or in the individual sheet in order to make it work. if its to confusing i can past a marco that work wit showing and hiding cells with multiple options/combinations.