Forum Discussion

Ignacio Vega Maza's avatar
Ignacio Vega Maza
Copper Contributor
Aug 26, 2017

Application.WorksheetFunction.Norm_S_Dist(Sheets(b).Cells(4, (i * 3)), True)

Good morning,

 

I've programmed the next instruction:

 

aux1 = Application.WorksheetFunction.Norm_S_Dist(Sheets(b).Cells(4, (i * 3)), True)

 

In a windows PC. When I tried to run in my mac (Excel 2011), it doesn't work. How can I solve it please?. Thanks.

Macros & VBA
Need Help

2 Replies

  • Deleted's avatar
    Deleted
    Aug 27, 2017

    Hello,

     

    as far as I know, the function Norm_S_Dist is not available in VBA for Excel for Mac 2011. So, if possible, you should use the older version NormSDist:

     

    =Application.WorksheetFunction.NormSDist(Sheets(b).Cells(4, (i * 3)))

     

    Or, e.g. as an alternative, calculate the required value in a cell by using the NORM.S.DIST function and then retrieve the cell value from VBA.

     

    Best

    Mourad

Resources