Tag Archives: Microsoft Scripting Runtime

Count Distinct Or Unique Values – VBA UDF

A handful of posts ago I looked at some FREQUENCY() formulae which could give a count of distinct or unique values in a given column. The formulae became quite complicated and slow – particularly when dealing with mixed data types – … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , , , , , , , , , , , , | 6 Comments

Excel 2013 Preview: Microsoft Scripting Runtime Errors

One of the first pieces of VBA code I intended to write in Excel 2013 involved using a Scripting.Dictionary object. Unfortunately, subsequent to the Office 2013 installation, if I tried to create any object from the scrrun.dll library I got … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , | Leave a comment