I offer services pertaining to any aspect of Excel and VBA. My Services page shows you examples of services I provide. You will also find a list of recent projects there.
I develop bespoke Excel tools for customers and also Excel add-ins for the general public, like my spreadsheet auditing tool RefTreeAnalyser. Check out products I have developed.
Go to LinkedInLearning for the only Excel course aimed at engineers: Excel for Engineering Professionals
Check out my Excel training page for other training options.
Subscribe to our news letter or check out the archive. There is no set frequency, I just post something when I have time. In any case, it is all about Excel.
I develop custom-made applications using Microsoft Office Excel® and VBA and Access and VBA to their full extent. Have a look at various (free) downloads, some of which have become the de facto standard for Excel developers around the world.
Would you like to learn more About me? On this page you can get to know me a little better and also find a short list of presentations I've given over the past years.
English and/or Dutch content
Updated: Flexfind JavaScript edition
Today I've updated my Flexfind (JS edition). I've added an option to either search in Values or in Formulas and Contiguous ranges are now displayed as one block (A1:B2) instead of as individual cells. To get the update, load the add-in in the usual way, click in it's pane and press control+F5
Tue, 04 Jun 2024 14:40:00 GMT
Flexfind was updated to fix a bug when the replace string contains a # character
Tue, 28 May 2024 16:00:00 GMT
RefTreeAnalyser has just been updated to version 3.1, build 211. Fixed issue with OK button of the ToC dialog not responding to a mouse click. Build 210 added: Now shows What's new, the first time an updated version is loaded. When timing formulas takes very long, RefTreeAnalyser will temporarily show an option to stop the timing. When you click the Precedents button (or its short-cut key) and an object is selected and not a range of cells, RefTreeAnalyser will show the references used by the object.
Thu, 23 May 2024 09:15:00 GMT
RefTreeAnalyser has just been updated to version 3.1, build 210. Now shows What's new, the first time an updated version is loaded. When timing formulas takes very long, RefTreeAnalyser will temporarily show an option to stop the timing. When you click the Precedents button (or its short-cut key) and an object is selected and not a range of cells, RefTreeAnalyser will show the references used by the object.
Wed, 22 May 2024 14:00:00 GMT
I have added a new article to my website today, in which I demonstrate a couple of LAMBDA functions: SheetName and JustifyText
Fri, 17 May 2024 16:45:00 GMT
Name Manager has just been updated to build 708. If you open the Add Name box, the current selection is already entered in the refersto formula
Fri, 17 May 2024 14:10:00 GMT
RefTreeAnalyser has just been updated to version 3.1, build 207. Fixed error on hard-coded number cells when sheet has no formulas. Improved performance of selecting nodes in the precedents tree. Fixed issue when running off-sheet references on a workbook with workbook protection.
Fri, 19 Apr 2024 10:15:00 GMT
I have added an example to my Office script examples page: how to filter a date column in a table for dates older than today.
Thu, 21 Mar 2024 10:50:00 GMT
Show All news