Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: quayz15
  • Content: Threads
  • Order by date
  1. quayz15

    VBA to VB 6.0

    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...
  2. quayz15

    non linear optimization with Excel solver

    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...
  3. quayz15

    Runge Kutta as UDF

    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
  4. quayz15

    Multi variable solver

    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...
  5. quayz15

    runtime error 9: subscript out of range

    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...
  6. quayz15

    For without next error.

    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...

Part and Inventory Search

Back
Top