Using Goal Seek in a formula

[nqueen]

Hi,

I have an excel sheet in which there are data. For a specific purpose, I need to make the target cell to 0 while changing another value. I used the goal seek and this works fine. The problem I have is that I need to use the Goal Seek for almost all cells in an entire row. And I need to do it periodically.

I would like to know if there is a way to call that Goal Seek as a function in a forumla? instaead of doing it manually.

Thanks in advance for your help!

 

[Remou]

This is Microsoft: Access Tables and Relationships Forum
Maybe:
VBA Visual Basic for Applications (Microsoft) Forum
forum707
Microsoft: Office Forum
forum68

 

[nqueen]

oups I m sorry I did not notice.
Thanks for letting me know !