Help to Create a Goal seek Loop for Ranges of cells

Hi,

So I have a spread sheet that is pulling some market data about options and updating in real time. What I want to do is calculate the implied volatility for the options at various strike prices. I can't seem to get the VBA codes to function on the ranges. I have a cell that give the difference from the model call/put price and I want to use a Goalseek code to make the volatility % change to keep the difference at 0 to give me the true market implied volatility.

My ranges are:

Call Difference: B26:K26 Named "Call_Diff"
Put Difference: L26:U26 Named "Put_Diff"

Implied Vol Call: B27:K27 Named "Call_Vol"
Implied Vol Put: L28:U28 Named "Put_Vol"

I feel like its simple but I can not solve the VBA code for it.

Thanks

This is the sample workbook, don't worry about the RTD function it's for a software I'm using.

Rotman Options Models (2).xlsm

I have this code working to goalseek the ranges! but now my issue is how do I make it run automatically when the row 26 is not "0"

Please Login or Register  to view this content.