ExcelBanter - GoalSeek Method failure

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - GoalSeek Method failure (https://www.excelbanter.com/excel-programming/321020-goalseek-method-failure.html)

Fixit_Steve[_2_]

GoalSeek Method failure

I can run a GoalSeek from the user interface in Excel 97, but when I try to
run it programmatically, I get a "GoalSeek Method of Range class failed"
error. I have the function running inside of the Worksheet Change procedure.

Any suggestions would be greatly appreciated.

Thanks in advance!

All times are GMT +1. The time now is 05:16 AM.