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
Bookmarks