Goal seek limits

Hey all,

I have a macro that does an automatic goal seek in a specified range. For some occasions, the results are obvious nonsense, so I wanted to add limits to the function. Is there an easy way to do this?

See Code below.

Thanks

Please Login or Register  to view this content.

This forum can be strict about using code tags around code, so I would suggest that you edit your post accordingly (instructions for adding code tags are in the FAQ's).

This is one of the reasons I don't use the Goal Seek utility very often. I prefer to use the Solver utility, which allows you to add constraints on decision variables or on the objective function or other cells in the spreadsheet. I would suggest that you become familiar with using Solver for your particular model, then learn how to call Solver from VBA.