Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Daily Download 7: Lateraly loaded pile analysis
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Retrieving unique values from a range or array ...
- Fitting high order polynomials
- LatPile - Analysis of Lateral Loads on Piles
- The angle between two vectors, Python version
Recent Comments
dougaj4 on Eval and Let examples dougaj4 on Eval and Let examples TB on Eval and Let examples dougaj4 on Eval and Let examples pgalvan@sigmaingenie… on Eval and Let examples dougaj4 on Eval and Let examples Craig on Eval and Let examples Craig on Eval and Let examples dougaj4 on Downloads Eval and Let example… on Evaluating text – u… Eval and Let example… on Evaluating text with units and… Eval and Let example… on Two New Functions; Let and… rhochoa81gmailcom on Downloads Ebony Buckle, New Sc… on George Gently, Matty Groves, a… dougaj4 on Numerical Integration With Tan…
Tag Archives: Excel 2007 performance
Importing tab delimited files and clearing large ranges
Wray Sisk commented on Importing text files with VBA – 3, asking if it could be modified to read tab delimited files. It could be, and has been; download here: Text-in2.ZIP It turned out to be a simple task; just … Continue reading
Posted in Excel, UDFs, VBA
Tagged Excel, Excel 2007 performance, import text, slow clearing, UDF, VBA
2 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
Worksheetfunction vs UDF
The previous post provided VBA code for a number of trigonometric functions, most of which are already available in Excel. Why bother you may say, why not just use the WorksheetFunction object? The numbers below provide the answer: Time to … Continue reading