Automate Goalseek using macro and vba

[fidu_k]

Hi,

I am trying to automate Goalseek using vba. Please see attached file.

What I want to do is goalseek by setting cell 'E6' to values in column 'A' by changing cell 'E8'. Then write the values in 'E8' to cell in column 'B'.

I am not sure what is wrong with the vba but it is not working.

Thank you.

[MrShorty]

It looks like you need to review the syntax for VBA's For..Next statement: https://docs.microsoft.com/en-us/off...next-statement VBA's For...Next requires that you specify the counter variable once. You have:

Please Login or Register  to view this content.

Should be

Please Login or Register  to view this content.

I deleted the extra "i=" and the code seemed to run fine.