I am new to programming. I have recently written a code in VBA for excel, and I need to write the same code in VB 6.0. I believe my trouble is I'm not sure how to define the element of an array as variables and use them in a function.
Any help is appreciated. the variables I am having trouble...
Is there a way to solve for a range of cells simultaniously? I need to best fit a curve where I need to set cells $E$14 : $E$417 = $D$14 : $D$417
by changing rows D2 : M2. Here is what I have, is there a way to adjust this code to do a best fit?
Sub BoucwenSOLVER()
For Row = 14 To 417...
Does anyone where to find an example of Runge-Kutta ODE integration written as a UDF for Excel? I need to intgrate another UDF so the Runge Kutta needs to use the function as an argument. Thanks in advance
I would like to know if what I want to do is even possible. I would like to create a solver that sets one range equal to another range by changing multiple variables.
Specifically, my target cell values for column "E" are currently in column "F"(ft=...) I would like to do this by changing the...
I am a new programmer, and I am trying to write a code that cycles though an excel spread sheet. Time is in the first column displace in the second and velocity in the third. I would like to process the data one row at a time. I am getting the runtime error when I try to calc acceleration...
I am trying to teach myself VB and this is my first real program. So, I'm sure this is a simple question. I'm trying to write a program that will process the information given by the manufacturer in a spread sheet, and predict the result. I'm sure that at this point there are many errors in the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.