Chris,
Try the macro recorder. Walk through the Goal Seek steps while recording.
Then you can run the macro in the Workbook_Change event.
Or you can probably create the required answer in the independent cell (the
one Goal Seek is changing) with a modified version of the formula in the
dependent cell. This would be if there are no circumstances where you would
manually enter a value into the cell.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
Chris said:
I want Goal Seek to update my spreadsheet automatically when certain
values are changed. Can someone walk me through how to do this in the
subroutine. I need specific instructions! Thanks!
