Tag Archives: Worksheetfunction

Worksheetfunction.Transpose – changed behaviour in Excel 2013 and 2016

It is (fairly) well known that when using Worksheetfunction.Transpose on an array in VBA the array must be no more than 65,536 (2^16) rows long, or it will return an error. Recently when using Excel 2016 (32 bit) I thought … Continue reading

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , , , | 6 Comments

Worksheetfunction vs UDF – 2

Previous Post In a recent post at microsoft.public.excel.programming Charles Williams (Decision Models) found that a VBA User Defined Funcion (UDF) searching through a defined range for a specified number was very much slower than simply using .worksheetfunction.match as below: Function VBAMatch2(arg … Continue reading

Posted in Excel, UDFs | Tagged , , | Leave a comment