Forum Discussion
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 (Exc...
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
Good morning,
Thank you very much. "NormSDist" works perfectly.