I have the following macro for updating values using Solver
I need the macro amended as follows:
Please Login or Register to view this content.
1) I need ValueOf:=72 to refer to cell F1
2) I need $E$$27 to refer to the last cell in Col D in ByChange:="$E$2:$E$27"
Your assistance in this regard is most appreciated
I have also posted on
https://www.mrexcel.com/board/thread...-code.1176711/
https://www.myonlinetraininghub.com/...ing-vba#p21541
Last edited by Howardc1001; 07-18-2021 at 10:14 PM. Reason: Amend Code
I have figured out all the code, except how to automatically change ValueOf:=72, to refer to cell F1 or its named range Sum_Val
It would be appreciated if someone could assist me
Please Login or Register to view this content.
You could try changing the line:
toPlease Login or Register to view this content.
Calling the "Simplex" engine you could use either Engine:=2 or EngineDesc:="Simplex LP" you don't need both even if excel adds both when recording a macro. Excel will also duplicate the Solver Set line.Please Login or Register to view this content.
so you macro could be simplified to this.
Please Login or Register to view this content.
Alf
Many thanks for the help Alf
You are welcome.
thanks for feedback and rep
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks