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
Update: RefTreeAnalyser
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
Name Manager has just been updated to build 706. Editing a name now also updates PowerQuery queries
Wed, 21 Feb 2024 15:30:00 GMT
I have just added a chapter to my article on solving startup problems in Excel, to solve an issue where Excel thinks it has lost the VBA code in a file
Wed, 14 Feb 2024 10:00:00 GMT
Flexfind was updated to add search and replace in Validation error message and input message text
Wed, 07 Feb 2024 15:00:00 GMT
Today my Name Manager (JS edition) has been updated. Get your update by clicking in its task pane and pressing control+F5. Changes include: Bug fixes and slight Ux improvements
Tue, 06 Feb 2024 13:30:00 GMT
RefTreeAnalyser has just been updated to version 3.1, build 206. New menu item: Select cells with hard-coded numbers
Tue, 30 Jan 2024 15:15:00 GMT
Today my Name Manager (JS edition) has been updated. Get your update by clicking in its task pane and pressing control+F5. Changes include: Now you can delete multiple names in one go
Tue, 30 Jan 2024 14:30:00 GMT
Show All news