"dragging" down the solver (macro needed)
 

Hello,

My name is Bart. I have a different call option price for every day o
the year and am solving for the implied volatility of the underlyin
asset for each of these days. Thus, because the option price change
every day, the input "to solve to" changes everyday as well.

I would be very greatful if anyone could tell me how to write a macr
that will take a different call price as the "to solve to" value.

Thanks,

Bar

--
bartdekler
-----------------------------------------------------------------------
bartdeklerk's Profile: http://www.excelforum.com/member.php...fo&userid=2011
View this thread: http://www.excelforum.com/showthread.php?threadid=34687