Excellent video Pamela, very clear and lovely explanation!
@luccasturari7926
Жыл бұрын
Thank you very much Pamela!!
@brw8186
4 жыл бұрын
Thank you so much, really appreciate it. I got stuck for 24 hours and now I can continue to my next project step :))
@permadisuryo3050
6 ай бұрын
Really great works, you are the mvp keep it up 👍
@batmojuice5704
4 жыл бұрын
Great tutorial. Thanks, especially the VB tricks. You saved me.
@EnriqueLagunes
Жыл бұрын
me hubiese gustado que lo enseñara a hacerlo desde el principio, pero fue un buen video ...
@annalauragabriele1811
6 жыл бұрын
I'm sorry for my english. Thanks for the video. I have a question to you, if you could answer me. in the past I used the solver in this way and it worked. But now that I need it again, it says: "compile error sub or function not defined". I followed all your steps. I write you the code: Sub Macro12() ' ' Macro12 Macro ' ' Sheets("Dimensionamento collettori").Select SolverReset SolverOk SetCell:="$P$2", MaxMinVal:=1, ValueOf:=0, ByChange:="$O$2:$O$66", _ Engine:=1, EngineDesc:="GRG Nonlinear" SolverAdd CellRef:="$N$2:$N$66", Relation:=2, FormulaText:="$P$2:$P$66" SolverOk SetCell:="$P$2", MaxMinVal:=1, ValueOf:=0, ByChange:="$O$2:$O$66", _ Engine:=1, EngineDesc:="GRG Nonlinear" SolverOk SetCell:="$P$2", MaxMinVal:=1, ValueOf:=0, ByChange:="$O$2:$O$66", _ Engine:=1, EngineDesc:="GRG Nonlinear" SolverSolve End Sub The first row became yellow. Can you help me? I can't understand where it's the problem.Thanks
@georgethanos1661
6 жыл бұрын
@Annalaura LaBorde Va ad Microsoft Visual Basic for Applications->Tools->References->seleziona (Clicka) sul Solver...e tutto έ bene nell' ultima linea (solversolve) aggiunge: solversolve userfinish:=True (il tavolo di solver chiude automaticamente) Si puό aggiunge (prima di SolverReset): Application Screen Updating = False e prima di End Sub: Application Screen Updating = True Questo per limitare il movimento dell Sheet.
@RandyOrtonX6
4 жыл бұрын
where you able to solve the problem? I have the same problem
@batmojuice5704
4 жыл бұрын
English: In the Visual Basic tool, open macro, go to Tools, References, and make sure “Solver” is checked, hit “ok”.
@Eduardo08020
4 жыл бұрын
@@batmojuice5704 Thankyou, I had the same problem and was able to SOLVE it with your help :p
Пікірлер: 14