|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
November 4th, 2003, 03:22 PM
|
|||
|
|||
VB problem in Excel..
I am working on a optimation problem in Excel and thought about making a macro to ease my work. But when I record a macro of what i am doing with the solver I get an error.
Here is what the macro recorded: "Sub Prodmix() SolverOk SetCell:="$B$15", MaxMinVal:=1, ValueOf:="0", ByChange:="$B$12:$B$14" SolverSolve End Sub" Here is my error msg: "compile error: Sub of function not defined."
|
|
#3
November 4th, 2003, 11:24 PM
|
||||
|
||||
|
CP- solver is a built in function of Excel that solves a lot of mathematical problems, such as linear analysis/programming, queuing analysis, statistics, etc...
__________________
Fisherman "Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
|
|
#5
November 5th, 2003, 06:50 AM
|
|||
|
|||
|
He didn't help me though...
 But someone else on another forum knew what I was talking about. Excel ****s up when it's making the macro: "Sub Prodmix() Solver Ok SetCell:="$B$15", MaxMinVal:=1, ValueOf:="0", ByChange:="$B$12:$B$14" Solver Solve End Sub" the text in red should be removed from the macro after making it. It works like sharm now 
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > VB problem in Excel.. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
