I am trying to automate a solver calculation in excel 2010 using VBA. I thought I had solver making correct calculations some time ago, but now it can't find the answer. It's so simple goal seek should even work but I prefer to use solver. I created and attached a very simple spreadsheet that should demonstrate the issue. The correct answer I'm looking for in cell E6 is 203.29.