Goal Seek in VBA

[Tebrica]

Hi Everyone,

I'd welcome piece of advice in understanding why goal seek function I run with VBA wouldn't give me exact solution (the variance is like 5-10%), vs. the one I'm using by ribbon Data/WhatIfAnalysis/Goal Seek...

I thought it might be because of starting point of the inputs, however I've also tried to re-run the code, but the number remain same distance from the target I'd like to have.

Is there a way to make it work?

Thanks in advance.

Regards,
Nemanja