I thought we over came the issue with formulas/values?
Anyway the attached has a doubleclick feature to calculate - i dont particually like it as any double click will invoke the macro so you will get error (that can be ironed out)
Currently only working if there is nothing around the numbers to sum, otherwise it picks up all numbers, will try and look later
|