Solver VBA issue with value of determination

[Heasham]

How to add cell to value of option ??

[MrShorty]

This forum can be very strict about putting code in code tags. Edit your post to include these tags to avoid getting your topic locked.

Solver cannot accept a cell reference in the "value of" field. I usually add a helper cell current_Function-target_value, then have Solver set that cell to a value of 0.

[shg]

Welcome to the board.

Please Login or Register  to view this content.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

[Heasham]

Thanks a lot i also used

Please Login or Register  to view this content.

and it worked

[shg]

You're welcome.