Search results

I am sorry Hui. I don't understand where is my mistake? Can you help me? Because, i saw that i doen t still works with Acidi + metalli, Anidridi + ossidi and Anidride + Idrossido. So, i thought that i am wrong something and i didn't understand what you said me. So, can you explain me better...

Hi Hui. Yes, it is. you can try to change "Integer" to "Variant" in solver's code. Then, you try to use and to solve the problems. Thank you for your interesting. Best regards

Sorry, i don't explain me well. Natural numbers goes to 1 from x number and they are just whole numbers (1,2,3,4,5...), while, Integer numbers includes decimal numbers and i don't want this result (0,1; 0,2; 0,3; 0,4; 0,5.....1; 1,1; 1,2....). I just want natural numbers like results. Anyway...

Sorry, I used your code and it gives me decimal numbers like results. It is wrong, because, i would just to have natural numbers. So, the question remains: why doesn't works when the minimum result (cell T24) is <> 0, while, Why Does it always work well when previous result of the equation was = 0?

Hi Hui. Thank you again for your help. Can you attach me your file. So, I can see that it works. Because i tried to do like you suggested me, but, it doesn t work again. So, i think that maybe i have made something mistakes

I choose to use EngineDesc:="Evolution", and it works well. But it remains a problem. It just works well when the target cell (T24) is already = 0. While, if the result of the equation before is <> 0. It works bad. I don't understand why does it happens? I attach my new file where you can see...

Sub RisDiffZero() Dim answer As Integer Application.EnableEvents = False SolverOk SetCell:="$T$24", MaxMinVal:=2, ValueOf:=0, ByChange:= _ "$B$9,$L$9,$AD$9,$AO$9", Engine:=1, EngineDesc:="GRG Nonlinear" SolverAdd CellRef:="$B$9", Relation:=1, FormulaText:="Variant"...

Hi Hui. Firstly, i want to thank you for your help. Unfortunately, it doesn't work like i would. Because, it has to work without to give me decimal numbers and if i put like constraints (FormulaText:="Integer") it give me these results. Anyway i have tried to do something changing in solver's...

Hi of all. The file that I attached, it is write in italian language. The part made in excel is compounded by: - Five button - 2 drop down menu - the central part that you see colored in green is for showing the result of calculation - the last part that is the result of reaction. The...

I have updated my file and now I use solver like Kenneth reccomended me. It functions enought well, but, i have still some problems that i can't solve. - When you will click on the button anidride + ossido, cells from AO to AT are empty, i created and saved another solver for overcome this...

I send you again my file. I applied some correction to my previous file. Maybe, somebody could have a new idea Regards.

Somebody know another way for solving this problem?

I tried to use excel's Solver like you suggested me. But, it doesn't give me a result with success. I don't know, why?

Hi Kenneth. As I have promised, i have fixed my errors into the file. I checked if Analysis Toolpak was installed...and it was Ok..you can find it in DATI-->ANALISI DATI. Now, i attached my file again, and i hope that you can help me to solve this Rubik's problem:) Thank you again.

Hi Kenneth. Thank you for your answer. Yes you have understood what is the problem and how we can solve it. Unfortunely, i saw that there was a wrong in the file atteched. I try to fix it and I post again. Thank you again for your willingness

Ok. I have fixed the last file that i attached some days ago. I post this file correct. So it miss of the automatically calculation of which i need I show you again the part of previous post. I would like that updating automatically numbers of the following cells: B9 L9 AD9 AO9 in such a...

In the button number 5 ("ANIDRIDI"+"OSSIDI") I have just added the single numbers of each element for doing the formula. For example: CO2 + CaO --> CaO3 and i have nothing of H2O molecule. So i hope that you understand what i mean and you can help me to solve these problems. If you want to do...

Thank you for your answer. This is critical point, because, it could happens two kind of situation: -The first three drop down menù function in a correct way with this formula, so it was just setting, while, -Number four and number five button (it begin with the word "ANIDRIDE"), repeat the...

Sorry.. I would only like to ask you of solving the second part about what i requested in the first post. The second problem is relative automatic calculation: I would like that updating automatically numbers of the following cells: B9 L9 AD9 AO9 in such a way that the following cells...

Hi of all. The file that attached in my request is write in italian language, but, matters that i ask you solved concern VBA. The part made in excel is compounded by: - Five button - 2 drop down menu - the central part that you see colored in green is for showing the result of calculation...