macro loan loop

hi im new to excel vba and im terribly stuck on something and was hoping somebody could help me
I need to use looping to make a loan schedule table until the loan is cleared. The macro i have written (see below) doesnt run and it keeps coming up with error but i cant see where im going wrong. if anyone could please help!

thanks in advance!

Please Login or Register  to view this content.

You need to explain what you require to be done. It will be good if you attach a sample file.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Also,

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.