vba functions

  1. M

    VBA Function for Correlation Matrix

    Hi, I'm new to using VBA, but looking to learn. I'm having trouble with the code for a correlation matrix function. The code is below and I keep getting a #NAME? error but I can't figure out where the issue is. Function CorrelationMatrix(rng As Range) As Variant Dim i As Integer Dim j As...
    • mikes_r
    • Thread
    • correlation function correlation matrix vba & excel 2016 vba functions
    • Replies: 7
    • Forum: Excel Questions
  2. Manolocs

    Rookie in VBA need help

    Hello, I just got a VBA function from a very nice user of this forum Mr. Peter_SSs. This is my first time using VBA/Macros, so I need some help to figure out what I am doing wrong. I have already the Developer TAB in excel 2013 PRO PLUS Macro security is Enable all Macros Thrust access to the...
  3. S

    Function call printing "True" after writing the value

    Hello all, I am calling a function from another function in VBA so, Its printing the return value and after that it is printing "True" I would like to get rid of that "True". Please suggest.
  4. C

    New to VBA, why won't my function work all the time?

    Hi folks, So im just learning VBA and i thought i could use it to replace one of my more complicated formulas. So basically what this does is calculates the mark to market of various contracts depending on type, pipe, and date. It ran fine for a while and all of a sudden i'm getting gaps...
  5. MarkCBB

    Formula function to VBA Function

    Hi There VBA People, I am currently using some VBA to insert this formula down 50,000 rows of data, then I copy the formulas and paste values. However I have been told that if i write the formula using proper VBA syntax it will calculate faster? and I wouldn't need to copy the results and paste...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top