Tag Archives: VBA

Formula Explorer Pro Beta 4.2

Posted on January 8, 2019 by fastexcel

After another 6 months on my quest to create the worlds best tool for exploring, validating, debugging and editing Excel formulas I have made Explorer Pro Beta 4.2 build 418.796 available. Hopefully this will be the final Beta! The improvements … Continue reading →

Posted in Calculation, Debug formulas | Tagged , , , | 7 Comments

Strategies for getting the last row in Excel with VBA

Posted on September 1, 2017 by fastexcel

Using VBA to get the last row in Excel can be a surprisingly complex task. This post will explore some of the different strategies you can use. The first thing to do is to decide what you mean by “The … Continue reading →

Posted in Excel, Formatting, VBA | Tagged , | 10 Comments

Excel JavaScript API Part 3: Benchmark of Processing Arrays Performance – Loop vs Reduce vs COUNTIFS vs VBA

Posted on March 16, 2017 by fastexcel

In a previous post I compared several different ways of processing data with VBA. The fastest way was to get the data into a variant array and loop on it. JavaScript has some powerful array methods so I wanted to … Continue reading →

Posted in arrays, JS-API, VBA | Tagged , , | 4 Comments

Excel JavaScript API Part 2: Benchmark of Read/Write Range Performance

Posted on March 13, 2017 by fastexcel

As an Excel Office Developer many of the Excel based applications I develop depend on reading data from Excel worksheet ranges, processing it and then writing the processed data back to a worksheet. In VBA the way to do this … Continue reading →

Posted in arrays, Calculation, JS-API, VBA | Tagged , , | 3 Comments

Excel Range.Value(ValueType): What is this parameter?

Posted on March 13, 2017 by fastexcel

Whilst visiting Microsoft Research in Cambridge I was chatting to fellow MVP Roger Govier. He mentioned that he was using this strange parameter to the Range.Value (ValueType) method, which I had been meaning to look at for a long time … Continue reading →

Posted in Formatting, VBA | Tagged , | 10 Comments

Excel JavaScript API Part 1: Overview & Comparison

Posted on March 13, 2017 by fastexcel

I have been spending time in the last few months experimenting with the new JavaScript Excel API. This is the first of a planned series of posts examining the JS-API from the point of view of an Excel Office developer. … Continue reading →

Posted in .NET, JS-API, UDF, Uncategorized, VBA, XLL | Tagged , , , , | 10 Comments

Excel Memory Checking Tool: Using LAA to increase useable Excel memory

Posted on November 27, 2016 by fastexcel

Most of us sooner or later get hit by one or more of the dreaded messages “Out of Memory” or “Excel cannot complete this task with available resources” or “Not enough System Resources/Memory to Display Completely” , regardless of how … Continue reading →

Posted in Memory, VBA | Tagged , , , , | 9 Comments