For Each Loop problem

[AndrewMac]

Hi All, Hoping you can help.

I am trying to create a repayment schedule for a loan using VBA. The loan has a number of variables - amount, grace period, repayment frequency. In the attached example the loan is for $20,000,000 and there will be no repayments for 52 weeks and thereafter repayments will be equal amounts every 4 weeks. I have been trying to do this with a For Each loop looping through the cells to be populated.

I attach a spreadsheet which hopefully makes the problem clearer.

Many thanks in advance,

Andrew