Dear All,
The VBA code runs but Solver references doesn't update properly. In Col I Solver only remembers Col Q references plus Range(H92:Q92) doesn't zero out.
<title>Excel Jeanie HTML</title>******>
<!-- ######### Start Created Html Code To Copy ########## -->
RES Var
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 129px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]2[/TD]
[TD="align: right"] 2018 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2020 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]80[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]2,010,356 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]2,273,836 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]2,254,752 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]1,978,988 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]1,130 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]2,096,530 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]981,120 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]1,329,598 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]1,676,217 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]940,391 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]1,978,790 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]1,570,310 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]2,717,934 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]81[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] , align: right"]0.09167192[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.1005[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.105621869[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.0001[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.1362[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.0743[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.0937[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.1183[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.0699[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.1168[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.0869[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.1178[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.0791[/TD]
[TD="align: right"]0.074989395[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]82[/TD]
[TD="align: right"]5.6%[/TD]
[TD="align: right"]5.9%[/TD]
[TD="align: right"]-99.9%[/TD]
[TD="align: right"]143180.3%[/TD]
[TD="align: right"]-42.5%[/TD]
[TD="align: right"]32.7%[/TD]
[TD="align: right"]32.9%[/TD]
[TD="align: right"]-37.8%[/TD]
[TD="align: right"]75.6%[/TD]
[TD="align: right"]-21.7%[/TD]
[TD="align: right"]42.8%[/TD]
[TD="align: right"]-29.2%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]83[/TD]
[TD="align: right"]5.1%[/TD]
[TD="align: right"]-99.9%[/TD]
[TD="align: right"]136100.0%[/TD]
[TD="align: right"]-45.4%[/TD]
[TD="align: right"]26.1%[/TD]
[TD="align: right"]26.3%[/TD]
[TD="align: right"]-40.9%[/TD]
[TD="align: right"]67.1%[/TD]
[TD="align: right"]-25.6%[/TD]
[TD="align: right"]35.6%[/TD]
[TD="align: right"]-32.9%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]84[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]85[/TD]
[TD="align: right"]0.1005[/TD]
[TD="align: right"]0.1056[/TD]
[TD="align: right"]0.0001[/TD]
[TD="align: right"]0.1805[/TD]
[TD="align: right"]0.0646[/TD]
[TD="align: right"]0.1007[/TD]
[TD="align: right"]0.1192[/TD]
[TD="align: right"]0.0646[/TD]
[TD="align: right"]0.1276[/TD]
[TD="align: right"]0.0812[/TD]
[TD="align: right"]0.1234[/TD]
[TD="align: right"]0.075[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]86[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]87[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]88[/TD]
[TD="align: right"]6,627,187 [/TD]
[TD="align: right"]6,503,032 [/TD]
[TD="align: right"]5,650,420 [/TD]
[TD="align: right"]3,378,568 [/TD]
[TD="align: right"]4,547,158 [/TD]
[TD="align: right"]3,831,142 [/TD]
[TD="align: right"]4,122,848 [/TD]
[TD="align: right"]4,120,767 [/TD]
[TD="align: right"]3,926,217 [/TD]
[TD="align: right"]4,948,151 [/TD]
[TD="align: right"]5,250,828 [/TD]
[TD="align: right"]6,764,256 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]89[/TD]
[TD="align: right"]76,181,424 [/TD]
[TD="align: right"]73,492,588 [/TD]
[TD="align: right"]64,138,566 [/TD]
[TD="align: right"]58,518,891 [/TD]
[TD="align: right"]47,041,022 [/TD]
[TD="align: right"]48,074,184 [/TD]
[TD="align: right"]48,072,808 [/TD]
[TD="align: right"]44,301,919 [/TD]
[TD="align: right"]49,845,329 [/TD]
[TD="align: right"]53,435,936 [/TD]
[TD="align: right"]62,985,744 [/TD]
[TD="align: right"]73,016,698 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]90[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]86.99[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]88.49[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]88.10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]57.73[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]96.66[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]79.69[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]85.76[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]93.02[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]78.77[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]92.60[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]83.37[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]92.64[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]91[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.99[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]88.49[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.26[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]85.58[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]85.51[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.41[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.49[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.80[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.89[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]87.52[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]88.05[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]92[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]1.83[/TD]
[TD="align: right"]-27.84[/TD]
[TD="align: right"]11.15[/TD]
[TD="align: right"]-6.41[/TD]
[TD="align: right"]-0.64[/TD]
[TD="align: right"]6.52[/TD]
[TD="align: right"]-8.03[/TD]
[TD="align: right"]5.71[/TD]
[TD="align: right"]-4.16[/TD]
[TD="align: right"]4.59[/TD]
</tbody>
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
<!-- ######### End Created Html Code To Copy ########## -->
Your help would be greatly appreciated.
Kind Regards
Biz
The VBA code runs but Solver references doesn't update properly. In Col I Solver only remembers Col Q references plus Range(H92:Q92) doesn't zero out.
<title>Excel Jeanie HTML</title>******>
<!-- ######### Start Created Html Code To Copy ########## -->
RES Var
A | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | ||
New $ | |||||||||||||||
New rate Ent ===> | |||||||||||||||
New rate Movt | |||||||||||||||
MoM% | |||||||||||||||
New Rate Cal | |||||||||||||||
Total $ | |||||||||||||||
Total Volume | |||||||||||||||
Overall Rate | |||||||||||||||
Required Rate | |||||||||||||||
var |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 129px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"><col style="width: 122px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]2[/TD]
[TD="align: right"] 2018 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2019 [/TD]
[TD="align: right"] 2020 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]80[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]2,010,356 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]2,273,836 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]2,254,752 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]1,978,988 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]1,130 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]2,096,530 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]981,120 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]1,329,598 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]1,676,217 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]940,391 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]1,978,790 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]1,570,310 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF6600]#FF6600[/URL] , align: right"]2,717,934 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]81[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] , align: right"]0.09167192[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.1005[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.105621869[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.0001[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.1362[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.0743[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.0937[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.1183[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.0699[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.1168[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.0869[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.1178[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFCC]#FFFFCC[/URL] , align: right"]0.0791[/TD]
[TD="align: right"]0.074989395[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]82[/TD]
[TD="align: right"]5.6%[/TD]
[TD="align: right"]5.9%[/TD]
[TD="align: right"]-99.9%[/TD]
[TD="align: right"]143180.3%[/TD]
[TD="align: right"]-42.5%[/TD]
[TD="align: right"]32.7%[/TD]
[TD="align: right"]32.9%[/TD]
[TD="align: right"]-37.8%[/TD]
[TD="align: right"]75.6%[/TD]
[TD="align: right"]-21.7%[/TD]
[TD="align: right"]42.8%[/TD]
[TD="align: right"]-29.2%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]83[/TD]
[TD="align: right"]5.1%[/TD]
[TD="align: right"]-99.9%[/TD]
[TD="align: right"]136100.0%[/TD]
[TD="align: right"]-45.4%[/TD]
[TD="align: right"]26.1%[/TD]
[TD="align: right"]26.3%[/TD]
[TD="align: right"]-40.9%[/TD]
[TD="align: right"]67.1%[/TD]
[TD="align: right"]-25.6%[/TD]
[TD="align: right"]35.6%[/TD]
[TD="align: right"]-32.9%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]84[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]85[/TD]
[TD="align: right"]0.1005[/TD]
[TD="align: right"]0.1056[/TD]
[TD="align: right"]0.0001[/TD]
[TD="align: right"]0.1805[/TD]
[TD="align: right"]0.0646[/TD]
[TD="align: right"]0.1007[/TD]
[TD="align: right"]0.1192[/TD]
[TD="align: right"]0.0646[/TD]
[TD="align: right"]0.1276[/TD]
[TD="align: right"]0.0812[/TD]
[TD="align: right"]0.1234[/TD]
[TD="align: right"]0.075[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]86[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]87[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]88[/TD]
[TD="align: right"]6,627,187 [/TD]
[TD="align: right"]6,503,032 [/TD]
[TD="align: right"]5,650,420 [/TD]
[TD="align: right"]3,378,568 [/TD]
[TD="align: right"]4,547,158 [/TD]
[TD="align: right"]3,831,142 [/TD]
[TD="align: right"]4,122,848 [/TD]
[TD="align: right"]4,120,767 [/TD]
[TD="align: right"]3,926,217 [/TD]
[TD="align: right"]4,948,151 [/TD]
[TD="align: right"]5,250,828 [/TD]
[TD="align: right"]6,764,256 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]89[/TD]
[TD="align: right"]76,181,424 [/TD]
[TD="align: right"]73,492,588 [/TD]
[TD="align: right"]64,138,566 [/TD]
[TD="align: right"]58,518,891 [/TD]
[TD="align: right"]47,041,022 [/TD]
[TD="align: right"]48,074,184 [/TD]
[TD="align: right"]48,072,808 [/TD]
[TD="align: right"]44,301,919 [/TD]
[TD="align: right"]49,845,329 [/TD]
[TD="align: right"]53,435,936 [/TD]
[TD="align: right"]62,985,744 [/TD]
[TD="align: right"]73,016,698 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]90[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]86.99[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]88.49[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]88.10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]57.73[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]96.66[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]79.69[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]85.76[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]93.02[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]78.77[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]92.60[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]83.37[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=008080]#008080[/URL] , align: right"]92.64[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]91[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.99[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]88.49[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.26[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]85.58[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]85.51[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.41[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.49[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.80[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]86.89[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]87.52[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]88.05[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]92[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]1.83[/TD]
[TD="align: right"]-27.84[/TD]
[TD="align: right"]11.15[/TD]
[TD="align: right"]-6.41[/TD]
[TD="align: right"]-0.64[/TD]
[TD="align: right"]6.52[/TD]
[TD="align: right"]-8.03[/TD]
[TD="align: right"]5.71[/TD]
[TD="align: right"]-4.16[/TD]
[TD="align: right"]4.59[/TD]
</tbody>
Spreadsheet Formulas | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody> </tbody> |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
<!-- ######### End Created Html Code To Copy ########## -->
Code:
Sub MultipleSolvers()
Application.ScreenUpdating = False
Dim i As Long, iStart As Long, iEnd As Long
'~~> This prevents an error at blank cells
On Error Resume Next
'SolverAdd(CellRef, Relation, FormulaText)
'
'CellRef Required Variant. A reference to a cell or a range of cells that forms the left side of a constraint.
'Relation Required Integer. The arithmetic relationship between the left and right sides of the constraint.
'If you choose 4, 5 or 6, CellRef must refer to decision variable cells, and FormulaText should not be specified.
'Relation Arithmetic relationship
'1 <=
'2 =
'3 >=
'4 Cells referenced by CellRef must have final values that are integers.
'5 Cells referenced by CellRef must have final values of either 0 (zero) or 1.
'6 Cells referenced by CellRef must have final values that are all different and integers.
iStart = Cells(1, "G").Column
iEnd = Cells(1, "Q").Column
For i = iStart To iEnd
Debug.Print "SetCell: " & Cells(92, i).Address
Debug.Print "ByChange: " & Cells(81, i).Address
Debug.Print "Number" & i
SolverReset
SolverOptions Precision:=0.001
SolverOk SetCell:=Cells(92, i).Address(0, 0), MaxMinVal:=3, ValueOf:=0, ByChange:=Cells(81, i).Address(0, 0), _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverAdd cellRef:=Cells(92, i).Address, relation:=3, formulaText:=0.001
SolverSolve userFinish:=True
Next i
'Application.ScreenUpdating = True
Application.Calculation = xlAutomatic
End Sub
Your help would be greatly appreciated.
Kind Regards
Biz