Search results for query: *

I need to use the functions weeknum and networkday, but in some computers these functions are not loaded. Is there any way to automatically load them when the spreadsheet is opened? Thanks Fernando

No, the cells that I'm trying to change are unlocked. I locked only the cells containing formulas. But it doesn't work. In particular it doesn't respect the constraints. Thank you again fernando

I have a worksheet to be protected in order to share it with other persons. The problem is that the sheet works running the SOLVER function and if I protect the sheet it doesn't work any more (I locked only the cells containing formulas or results). Is there any solution? Thank you fernando

Hi, I have this problem: I need to make interact the macro of my program with the solver function of Excel. If I launch the solver, as I normally do from the Tools menu, the macro is not runned, so I tried to run the solver function using the following sintax: The sub Losses Estimation is...

Hi ETID, thank you for your quick reply. Sorry, but I'm not an expert of VBA and my problem is just how to make interact the macro of my program with the solver function. If I launch the solver as I normally do the macro is not runned, so I tried to run the solver function using the following...

Hi, I'd like to know if somebody can explain to me how to use the SOLVER function of Excel running a VBA macro instead of running it from the Tools menu of Excel Thanks in advance Bye Fernando

I've this problem. I need to run the SOLVER function clicking a button in an excel spreadsheet. The problem is that the spreadsheet already works with a iterative macro. When I launch the solver the remaining part of the macro is not runned, therefore the solution is not the optimal one. Does...