I am trying to create a macro that allows a cell reference to be used for the "To Value" field in Goal Seek. I have created the code, but it will only work if I put a number value in for the "To Value." If this can't be done, is there a macro I can create to set an equation equal to a referenced cell by changing another parameter? I'd like to make it so that the spreadsheet user for my particular program does not have to go through the Goal Seek process every time the data is changed. If anyone could please help I would appreciate it. Thank you.