Hi,

I am wanting to perform a goal seek on multiple cells, and want to automate the processing of this goal seek via VBA.

My sheet looks like the below.

I want to understand the minimum offer rate for a series of discounted cashflows on 2,000 rows of data (the Offer Price column has the following formula.

=NPV("Offer_Rate"/12,AL5:DZ5 ("SERIES OF CASHFLOWS")

So, i need to Goal Seek to find the Offer Rate for each series of cashflows, such that the above formula returns a break-even (i.e. the P&L) column is zero.

Is there some VBA code i could use rather having to manually goal seek each row.

Thansk

Dave

I am wanting to perform a goal seek on multiple cells, and want to automate the processing of this goal seek via VBA.

My sheet looks like the below.

Offer Rate | Offer Price | P & L | Contract Cashflows >>>> SUM OF MAR 21 ONWARDS | Mar-21 | Apr-21 | May-21 | Jun-21 | Jul-21 | Aug-21 | Sep-21 | |

3.45% | £10,789.48 | £0.00 | £11,337.40 | £324.22 | £324.22 | £324.22 | £324.22 | £324.22 | £324.22 | £324.22 |

I want to understand the minimum offer rate for a series of discounted cashflows on 2,000 rows of data (the Offer Price column has the following formula.

=NPV("Offer_Rate"/12,AL5:DZ5 ("SERIES OF CASHFLOWS")

So, i need to Goal Seek to find the Offer Rate for each series of cashflows, such that the above formula returns a break-even (i.e. the P&L) column is zero.

Is there some VBA code i could use rather having to manually goal seek each row.

Thansk

Dave