![]() ![]() ![]() I try to figure out but i am still at the same point. Re: Using mmult function highlighting the correct cells (in the uploaded file: D8 to G10) then pressing F2 and lastly, CTRL+SHIFT+ENTER will give you the complete array result but what i'm looking for is how to do it automatically without using F2 and CTRL+SHIFT+ENTER. Range("I7").Value = WF.MMult(WF.Transpose(rng1.Value), av)ī圜hange:=Range("B6:B10") ' Minimizing Portfolio RiskĬells(13 + i * 12, Compte).Value = Range("I6").Value ' Portfolio returnĬells(14 + i * 12, Compte).Value = Range("I7").Value ' Portfolio RiskĬells(15 + i * 12, Compte).Value = Sqr(Range("I7").Value) ' Portfolio STDEVĬells(17 + i * 12, Compte).Value = Range("B6").ValueĬells(18 + i * 12, Compte).Value = Range("B7").ValueĬells(19 + i * 12, Compte).Value = Range("B8").ValueĬells(20 + i * 12, Compte).Value = Range("B9").ValueĬells(21 + i * 12, Compte).Value = Range("B10").Valueīut i am sure i have made a lot of mistakes with my loops and the above coding doesn't work at all, my VBA says that my Next is not defined. User has to elect to open this new file as NON-read-only in order to get the add-ins to work. Excel tries to create a read-only duplicate of the file already open. ![]() User gets security notice below and clicks the 'Enable' button. Range("I6").Value = WF.SumProduct(rng1.Value, rng2.Value) User navigates to 'Add-Ins' tab at top of page and chooses an add-in to run. Set rng2 = Worksheets("D(1)").Cells(iRow, "V").Resize(5) This makes the function much easier to call especially when working with multiple tables. ![]() Now i want to implement the solver in my calculation such as in follow : Ok, it seems that it works, thanks for the tips. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |