I have a two part question...Is it possible to create a macro so one can use a cell reference instead of an absolute value in the 'To value' field in goal seek? Also somewhat related to this, is there a way to use autofill using goal seek, ie, I am fitting a parameter in an equation and want to be able to drag down a series of values instead of having to use goal seek for each line.

Thanks!