goal seek function

Dear All,

A marco recorded using the macro recorder has the below code

Range("C15").GoalSeek Goal:=10000, ChangingCell:=Range("C7")

Is there any way to replace the 10000 with a relative cell reference say value in cell A1

Thanks
Rodney

Since no one else has yet answered -- I'm not familiar with the goalseek function, so could you explain in plain terms what you're trying to do exactly? If you can, post an example worksheet -- it'll help people like me who can't always visualize from text.
As is often the case in vba, there is probably more than one way to solve your problem, so if no one responds who knows enough about goalseek, if you post what your overall issue is instead, you may still get an adequate answer.