I used the loop code below in Microsoft Visual Studio 8 and am trying to get it to work in Excel’s VBA. The Cos and Sin function seem to be the problem, is there any way to get it to work?
Thanks Sandy.
My only thought was to some how get Fun_3 by writing the Fun_1 and Fun_2 formula into Excel during a Loop until Fun_1 = 0??
Please Login or Register to view this content.
Sin and Cos are native functions in VBA.
Entia non sunt multiplicanda sine necessitate
Thanks for that, I must have other problems which I will try to sort.
Sandy
You've got more variables than you need, and you initialize two of them from the same cell, which looks dubious.
EDIT: Also, you should probably be looping until Fun1 is less than (perhaps in absolute value) some epsilon.Please Login or Register to view this content.
Last edited by shg; 09-13-2009 at 04:46 PM.
Thanks SHD, now we are winning. My maths is a little rusty.
Sandy
Sandy, you could do this instead with Solver. It would probably be faster.
You could also automate Solver to do it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks