How Can I Integrate Fixed Point Iterations with Excel Using VBA?

  • Thread starter Thread starter Bradracer18
  • Start date Start date
  • Tags Tags
    Fixed point Point
Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
2 replies · 3K views
Bradracer18
Messages
203
Reaction score
0
Hey guys...I'm not real smooth with programming, but I've got some of it done.


I need to use the formulas I have in the code, and export the data back into my excel sheet...The first Do-Loop is for the Fixed Point iterations, and the second part is for the NR method. I just need to learn how to make this get me my numbers into the spots on the sheet.


I'm not sure what I have is correct(other than the formulas).


If you guys can advise me, or show me once...I can probably do my best to carry it on.

Thank you,
Brad

***Ok, well it didn't let me attach the file...so I'm not sure what to do...

Can anyone help me out still...or maybe direct me to a website??
 
Physics news on Phys.org
Actually, I mostly figured it out...I'll probably be posting more, as the year goes on...Thanks for the help tho!

Is there any way to post a macro...or the excel file?