Goal Seek function question.

[sungen99]

I have a good idea of how to use the goal seek function now in vba but how do I tackle this request.

H26 is the formula that is showing a profit.

I am trying to make H26 the HIGHEST profit I can using numbers between 500 and 850.

[MrShorty]

Part of the reason I tend not to use Goal Seek is because it is somewhat limited in functionality. The Solver add-in might be a better choice, because Solver allows you to specify "constraints" on the problems variables, such as "input variables X,Y,Z are numbers >= 500 and <=850.