Hi All,
I've got a goalseek within a VBA loop which comes up with an error. It works in isolation, and I've checked the obvious things like the cells in the goalseek linking and being formulae.
I've turned auto-calc off, would this have an effect?
Code below, bit where is goes wrong is...