Results 1 to 7 of 7

Thread: Matrix multiplication in VBA (not the application. one)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,709
    Location
    Break it down
    Sub a()
        Dim Nomin As Double
        Dim Denom As Double
        Dim WsF As Object
        Set WsF = Application.WorksheetFunction
        With WsF
            Nomin = (.MMult(.MMult(.Transpose(onevector), .MInverse(Sigma)), ExcessMu))
            Denom = (.MMult(.MMult(.Transpose(ExcessMu), .MInverse(Sigma)), ExcessMu))
        End With
        TMVMuTanN = Nomin / Denom
    End Sub
    Last edited by Aussiebear; 03-19-2025 at 06:31 PM.
    Please take the time to read the Forum FAQ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •