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.
I offer both pre-scheduled trainings and custom-made courses. Content of trainings can be adapted to your needs. If preferred we also offer any course as an in-house training.
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: Name Manager
Name Manager has just been updated to build 703. Removed 240 character limitation from the Edit RefersTo box
Thu, 31 Aug 2023 16:30:00 GMT
Flexfind was updated with an improved report (the List button)
Wed, 30 Aug 2023 13:55:00 GMT
I have added an example to my Office script examples page: how to enter zeroes in all empty cells in a range.
Thu, 17 Aug 2023 11:10:00 GMT
Flexfind now also searches the formulas in conditional formatting rules such as data bars, color scales and icon sets
Tue, 20 Jun 2023 14:20:00 GMT
This little add-in makes resizing rows and columns very simple.
Thu, 15 Jun 2023 16:30:00 GMT
This little add-in prevents an irritating habit of Excel: It reduces the width of the Queries and Connections pane very often.
Fri, 26 May 2023 12:35:00 GMT
If you use Styles in VBA, watch out for international issues!
Tue, 16 May 2023 16:55:00 GMT
Good news: As of now, Flexfind allows you to Search and replace in VBA too!
Mon, 13 Mar 2023 10:55:00 GMT
Good news! Today my brand new Flexfind (JS edition) has been approved for the Microsoft Office Add-ins store!
Thu, 19 Jan 2023 16:45:00 GMT
RefTreeAnalyser has just been updated to version 3.1, build 190. Fixed a bug that caused run-time errors when using the Check Formulas option. Made the dialogs compatible with screen reader software for the visually impaired. First build that is Mac compatible!
Thu, 12 Jan 2023 15:55:00 GMT
Our All VBA treeview control has been updated to version 26.5. It has been improved for accessibility and is now compatible with the Windows Narrator screen reader (for the visually impaired).
Tue, 10 Jan 2023 15:45:00 GMT
I've Updated two tools today: GithubVBAExporter and FollowCellPointer. Find them on the download page.
Wed, 14 Dec 2022 14:30:00 GMT
RefTreeAnalyser has just been updated to version 3.1, build 189. If your formula returns a range reference (like the XLOOKUP function does), RefTreeAnalyser will display to which cell(s) the formula points.
Wed, 02 Nov 2022 12:45:00 GMT
I presented during the Excel Virtually Global conference October 17, 2022, Here's the recorded video: Office Script And Power Automate Demo
Mon, 17 Oct 2022 08:00:00 GMT
Een beveiliginsupdate heeft ervoor gezorgd dat Office bestanden met VBA code die je download (waaronder ook invoegtoepassingen) niet meer werken. Dit artikel laat zien hoe je dit probleem oplost.
Wed, 12 Oct 2022 09:25:00 GMT
RefTreeAnalyser has just been updated to version 3.1, build 187. RefTreeAnalyser now also enables you to move your mouse over a sheet and see all cells with the same formula highlighted.
Thu, 22 Sep 2022 14:00:00 GMT
Name Manager has just been updated to build 700. Fixed an issue pertaining to renaming and using the pickup function for users using an international keyboard
The Excel File Remediation Utility has been updated to build 133. Fixed a bug in the logging routine which causes errors when Windows is using a period as the date separator. Please manually download the new version as it looks like the update process also causes errors.
Tue, 02 Aug 2022 10:55:00 GMT
Name Manager has just been updated to build 696. Name Manager now works together with Charles Williams Lambda Explorer if you've got that installed
Tue, 26 Jul 2022 10:50:00 GMT
Name Manager has just been updated to build 695. Fixed a bug regarding listing all names on a protected workbook
Mon, 18 Jul 2022 13:15:00 GMT
Flexfind has been updated: Added a textbox which displays the text in which your search string was found. Highlights the search string.
Wed, 13 Jul 2022 10:45:00 GMT
Name Manager has just been updated to build 694. IT IS NOW FULLY COMPATIBLE WITH MAC EXCEL!
Wed, 13 Jul 2022 09:15:00 GMT
I have updated the TableTools add-in. I'm updating the add-in so it also works on Mac Excel
Mon, 06 Jun 2022 10:45:00 GMT
I've added three new Excel and VBA tips and tricks to the Tips and tricks page today.
Fri, 03 Jun 2022 12:00:00 GMT
Flexfind has been updated: Some improvements to the UI and to Mac compatibility
Fri, 27 May 2022 13:15:00 GMT
Flexfind has been updated: Now allows search in autoshapes. New: Mac compatible!
Wed, 25 May 2022 15:45:00 GMT
RefTreeAnalyser has just been updated to version 3.0, build 177. RefTreeAnalyser now also enables you to add a table of external links to the Table Of Contents of your workbook.
Mon, 02 May 2022 10:15:00 GMT
Wed, 20 Apr 2022 12:15:00 GMT
I have updated the article about enabling drag and drop between two listboxes on an Excel userform with some improvements, like enabling multi-column listboxes. I've also fixed a couple of bugs.
Wed, 09 Mar 2022 13:20:00 GMT
A new page featuring all sorts of Excel and VBA tips and tricks.
Fri, 25 Feb 2022 15:40:00 GMT
The Microsoft VBA editor was designed somewhere around 1996. This means that the standard design of the userforms you create with that editor look really old-school if you don't do anything. Here I show how we might create a more modern-looking user-interface by changing some properties of the form and by using some tricks..
Wed, 16 Feb 2022 16:45:00 GMT
RefTreeAnalyser has just been updated to version 3.0, build 175. The new feature to count all UDFs and LAMBDAs in your file has been vastly improved. And RTA now uses the top-left cell of a spill range to find formula precedents.
Mon, 14 Feb 2022 15:40:00 GMT
RefTreeAnalyser has just been updated to build 174. Improved Select cells with dependents; Added counting UDF and LAMBDA functions.
Wed, 9 Feb 2022 15:45:00 GMT
I have updated the article about enabling drag and drop between two listboxes on an Excel userform with some improvements, including making the target box scroll up or down when there are more items than fit in the height of the listbox.
Tue, 11 Jan 2022 10:30:00 GMT
I have added an example to my Office script examples page. Office Script does not (yet) offer a way to prompt for input. I invented a work-around: Check for a presence of an input sheet. If not there, Insert it into the file and populate it with a prompt and labelled input cells. If it is already there, assume all inputs are ready and continue running the script and perform its actions.
Mon, 13 Dec 2021 16:45:00 GMT
Flexfind has been updated: Now allows search in threaded comments.
Mon, 06 Dec 2021 14:35:00 GMT
I've updated this article with the new feature to start a script from a button on a sheet.
Tue, 30 Nov 2021 10:55:00 GMT
Ik heb dit artikel bijgewerkt met een nieuwe optie om een script te starten middels een knop op het werkblad
I've updated the tool with some UI improvements.
Mon, 15 Nov 2021 10:15:00 GMT
RefTreeAnalyser 2.0 has just been updated to build 170. Improved sorting of chart series nodes on Objects dialog and fixed truncation of some labels on dialogs.
Wed, 10 Nov 2021 10:45:00 GMT
Excel is a very serious and powerful business application. That doesn't mean we can't have some fun with it. This file shows how to use circular references to have a tombola, no programming involved!
Fri, 29 Oct 2021 13:45:00 GMT
I have updated this utility today. It now enables you to get a list of the properties of all userforms (including all their controls) appended at the end of the textfile. ExportVBAProject writes the components from a VBAProject to a single text file. Very useful if you need to compare the VBA code of two Excel files. Use a text compare tool like ExamDiff to compare differences in the exported files.
Thu, 28 Oct 2021 15:45:00 GMT
I've updated the tool so it also works on files stored in Sharepoint or OneDrive.
Wed, 20 Oct 2021 09:45:00 GMT
I've fixed a bug in the tool which caused the tool not to work with numeric indices.
Mon, 18 Oct 2021 16:30:00 GMT
In this new article, I show you how to apply an Office Script to all Excel files in a OneDrive (for business) folder. The script adds a Table of Contents sheet (which neatly lists all worksheets and all charts) to each Excel file in the folder.
Fri, 08 Oct 2021 16:30:00 GMT
Sinds Juli 2020 kunnen Microsoft 365 gebruikers hun acties in Excel laten opnemen als Office Script macro's. Eerder plaatste ik al een artikel dat laat zien hoe je hiermee start. Op deze pagina toon ik wat voorbeelden van Office scripts die je niet kunt opnemen met de Script recorder, maar die wel nuttig zijn.
Thu, 26 Aug 2021 13:05:00 GMT
Since 2020, Microsoft 365 users can record their actions in Excel on-line into Office Script macros. This article shows example scripts which you cannot record but might come in handy.
Tue, 24 Aug 2021 15:45:00 GMT
RefTreeAnalyser 2.0 has just been updated. Fixed an issue with the links on each sheet back to the ToC.
Fri, 20 Aug 2021 13:30:00 GMT
RefTreeAnalyser 2.0 has just been updated. Added Tables to the table of content option.
Tue, 17 Aug 2021 17:20:00 GMT
RefTreeAnalyser 2.0 has just been updated. Added Form and ActiveX controls to the table of content option.
Fri, 13 Aug 2021 16:10:00 GMT
A long time ago I wrote an article about how to best import text files into Excel. I've updated the article today to include the PowerQuery steps.
Wed, 11 Aug 2021 15:00:00 GMT
Many users struggle with getting rid of an Excel add-in. In this article I show how to fix the infamous "Sorry, we could not find..." error message.
Wed, 14 Jul 2021 14:45:00 GMT
Many users struggle with getting an add-in installed. In this article I show some VBA code that will ease that process: As soon as the user opens the add-in and enables macros, the add-in offers to install itself.
Mon, 12 Jul 2021 13:40:00 GMT
Sinds 2020 kunnen Microsoft 365 gebruikers hun acties in Excel online opnemen tot Office Script macro's. Dit artikel laat zien hoe je daarmee begint. Later zal ik nog wat voorbeeld scripts plaatsen die niet kunnen worden opgenomen, maar wel handig kunnen zijn.
Thu, 08 Jul 2021 13:45:00 GMT
Een artikel over de nieuwe Excel LAMBDA functie: hoe maak ik mijn eigen Excel functies.
Tue, 06 Jul 2021 12:40:00 GMT
Since 2020, Microsoft 365 users can record their actions in Excel on-line into Office Script macros. This article shows you how to get started. Later on, I will list some example scripts which you cannot record but might come in handy.
Mon, 05 Jul 2021 16:00:00 GMT
The new Excel LAMBDA function: how to convert well-known VBA structures into combinations of Excel functions in a Lambda.
Tue, 08 Jun 2021 16:50:00 GMT
An article about the new Excel LAMBDA function: how to create your own Excel functions.
Wed, 02 Jun 2021 14:15:00 GMT
I have updated GitHubVBAExporter, the form is now sizable.
Wed, 28 Apr 2021 11:00:00 GMT
Name Manager has just been updated to build 681 with some bugfixes
Thu, 15 Apr 2021 13:10:00 GMT
I have updated a number of tools to cater for some 64 bit issues and other things. These include files such as Name Manager, FlexFind, GitHubVBAExporter, Autosafe.
Mon, 22 Mar 2021 12:30:00 GMT
I've updated Github VBA Exporter. It now allows you to also export add-ins. This utility enables you to export all components from a VBAProject to a user-selectable set of folders. Very useful if you need to upload the contents of a VBA project into Github. The tool generates a textfile which contains all properties of all userforms and their controls, and the ribbonX is exported too, which enables you to do diff's on your user interface.
Thu, 18 Mar 2021 11:50:00 GMT
I've added a tool (in beta!!) to my download section called Github VBA Exporter. This utility enables you to export all components from a VBAProject to a user-selectable set of folders. Very useful if you need to upload the contents of a VBA project into Github. The tool generates a textfile which contains all properties of all userforms and their controls, and the ribbonX is exported too, which enables you to do diff's on your user interface.
Wed, 13 Jan 2021 10:30:00 GMT
Name Manager has just been updated to build 675. You can now filter for Lambda names and you can edit name comments
Mon, 14 Dec 2020 13:55:00 GMT
RefTreeAnalyser 2.0 has just been updated. Added two new options: 1. Generate a Table of Contents and 2. Added a feedback button which takes you to a small survey so you can tell me what you like and what you do not like.
Fri, 04 Dec 2020 11:00:00 GMT
I presented during the Excel Virtually Global conference in July 2020, Here's the recorded video: Smart VBA Macro Recording
Mon, 24 Aug 2020 16:15:00 GMT
I have updated my existing article on how to prevent Open events from running as Microsoft has changed the way Excel responds to the Shift key being held down (it now ignores it).
Thu, 13 Aug 2020 16:15:00 GMT
I have added an article today which shows how to enable drag and drop between two listboxes on an Excel userform
Wed, 10 Jun 2020 10:30:00 GMT
Ik heb een artikel toegevoegd over het gebruik van Gegevenstypen in Excel.
Thu, 21 May 2020 16:00:00 GMT
I have added an article today about data types in Excel.
Fri, 08 May 2020 15:20:00 GMT
I have added an article today about what every spreadsheet models should contain. With a free download too!
Fri, 01 May 2020 17:40:00 GMT
Ik heb een artikel toegevoegd vandaag over wat er in ieder goed Excel bestand zou moeten zitten. Met gratis download.
I have scheduled a new run of my Excel VBA Masterclass for these dates: May 18, 20, 26 and 28, 2020 June 2 and 4, 2020. The masterclass will be completely on-line, using Microsoft Teams. Make sure you register now
Thu, 23 Apr 2020 09:25:00 GMT
RefTreeAnalyser 2.0 has just been updated. Added PowerQuery M code to Object search. Fixed a bug regarding finding cell references in Objects
Wed, 15 Apr 2020 10:55:00 GMT
I've fixed two bugs in the tool.
Fri, 10 Apr 2020 15:00:00 GMT
Name Manager has just been updated to build 672. Range names generated by the new LET function are now correctly identified as system names
Wed, 1 Apr 2020 10:40:00 GMT
Name Manager has just been updated to build 671. When a name is renamed, PowerQuery M code will be checked for existence of the name and updated accordingly
Fri, 21 Feb 2020 13:40:00 GMT
Ever used Format as Table in Microsoft Excel? Did you know Format as Table can be a whole lot more than just fancy formating? Join Jan Karel Pieterse as he discusses working with tables and how they can help you in your everyday work with Excel.
Fri, 31 Jan 2020 10:50:00 GMT
RefTreeAnalyser 2.0 has just been updated. You can now choose whether or not to display references in your formula more than once
Wed, 15 Jan 2020 09:20:00 GMT
I have updated the TableTools add-in, with a couple of bug fixes.
Mon, 13 Jan 2020 13:30:00 GMT
I have scheduled a new run of my Excel VBA Masterclass. Make sure you register now
Tue, 26 Nov 2019 12:45:00 GMT
To help in the battle towards better spreadsheets I have uploaded an Excel Spreadsheet Model Template.
Wed, 20 Nov 2019 09:05:00 GMT
RefTreeAnalyser 2.0 has just been updated. Fixed the wrong calculation setting (use 1 core only) of the add-in
Tue, 12 Nov 2019 09:45:00 GMT
The Excel File Remediation Utility has been updated to build 128. Added "Copy sheet special" item to right-click menu of worksheet tabs.
Thu, 31 Oct 2019 09:15:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved the layout of the Object references dialog
Wed, 30 Oct 2019 16:15:00 GMT
I have updated the page on VBA driven circular reference calculations
Tue, 22 Oct 2019 11:45:00 GMT
RefTreeAnalyser 2.0 has just been updated. Fixed issue where references are not found when formula contains new line character (alt+enter).
Thu, 26 Sep 2019 12:15:00 GMT
Today I've posted the solutions I received for my Excel challenge of August 2019 named Combinations, Combinations.
Thu, 19 Sep 2019 14:00:00 GMT
I've enabled the Compare2Tables tool to work on 64 bit Excel.
Tue, 03 Sep 2019 14:50:00 GMT
I have added a download file to the article on how to synchronize slicers from different caches.
Thu, 29 Aug 2019 15:05:00 GMT
RefTreeAnalyser 2.0 has just been updated. I have improved the Check Formulas interface.
Tue, 06 Aug 2019 16:19:00 GMT
RefTreeAnalyser 2.0 has just been updated. I have fixed a small bug pertaining to hard-coded strings in formulas.
Mon, 29 Jul 2019 16:45:00 GMT
I have updated my little article on corrupt Excel files.
I've just fixed a bug in the class module which caused errors when you would minimize an Excel window. Thanks to Philippus, who reported this bug.
Mon, 01 Jul 2019 09:45:00 GMT
I've added a feature to the Compare2Tables tool. You can now select which difference tables you want the tool to produce.
Tue, 02 Apr 2019 16:40:00 GMT
RefTreeAnalyser 2.0 has just been updated. I have added a feature where pressing find precedents on a Pivot chart will select the underlying pivottable.
Tue, 26 Mar 2019 12:55:00 GMT
I've added a tool (in beta!!) to my download section called Compare2Tables.
Mon, 25 Feb 2019 17:00:00 GMT
Name Manager has just been updated to build 666. Name Manager will now recognize names starting with _xlfn as Excel system names.
Tue, 22 Jan 2019 13:50:00 GMT
Flexfind has been updated with a small number of improvements: better search in chart items and better grouping of cells with identical formulas.
Wed, 16 Jan 2019 07:50:00 GMT
I updated the TableTools add-in, with a couple of bug fixes.
Mon, 12 Nov 2018 15:15:00 GMT
I updated the TableTools add-in, which now ensures name changes of Tables are updated in PowerQuery queries!
Fri, 09 Nov 2018 08:30:00 GMT
I'm scheduling a new run of my Excel VBA Masterclass soon.
Wed, 31 Oct 2018 13:45:00 GMT
RefTreeAnalyser 2.0 has just been updated. I have fixed a bug regarding getting references from chart series.
Come and join me in Ljubljana November 5th, 2018 for The Ljubljana Excel VBA Masterclass. Make sure you Visit the Website
Mon, 1 Oct 2018 15:55:00 GMT
Updated: Flexfind. Flexfind was updated to build 595 in which I fixed an issue when searching across multiple workbooks.
Mon, 1 Oct 2018 15:35:00 GMT
Name Manager has just been updated to build 664. Name Manager will no longer mark names using the new Dynamic Array references as names with errors.
Wed, 26 Sep 2018 15:45:00 GMT
RefTreeAnalyser 2.0 has just been updated. It now works with the new Excel Data Types (Geography and Stock) and with the new Dynamic Array references.
Wed, 26 Sep 2018 15:15:00 GMT
Name Manager has just been updated to build 660. In case of a compile error, Name Manager will automatically turn off its feature to display a toolbar in the VBA editor.
Tue, 04 Sep 2018 16:00:00 GMT
Name Manager has just been updated to build 659. Fixed a problem 64 bit Excel users might experience.
Mon, 03 Sep 2018 16:35:00 GMT
My HeaderFooter tool has been made 64 bit compliant.
Fri, 24 Aug 2018 14:05:00 GMT
Name Manager has just been updated to build 958. Fixed a problem caused by a Windows 10 bug.
Fri, 06 Jul 2018 14:05:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved performance of formula checking and reporting significantly.
Thu, 14 Jun 2018 19:05:00 GMT
Ik weet het, saaaaai. Maar het moest er van komen ivm de AVG. Ons Privacy Beleid is aan onze site toegevoegd.
Mon, 28 May 2018 10:25:00 GMT
I know, boring, but it had to be done thanks to the GDPR. Our Company Privacy Policy has been added to our website.
RefTreeAnalyser 2.0 has just been updated. Adapted site addresses to use https.
Thu, 24 May 2018 16:15:00 GMT
The Excel File Remediation Utility has been updated to build 123. Adapted site addresses to use https.
RefTreeAnalyser 2.0 has just been updated. Fixed runtime error due to third-party add-ins when checking if tool is installed.
Wed, 02 May 2018 16:15:00 GMT
RefTreeAnalyser 2.0 has just been updated. Included Array formulas in circular reference checks.
Mon, 09 Apr 2018 17:00:00 GMT
Ik heb een artikel toegevoegd vandaag over hoe je Gebruikers-vriendelijke gegevensvalidatie met weergave van hulp die niet in de weg staat maakt in Excel.
Sat, 17 Mar 2018 16:00:00 GMT
I have added an article today about Creating a user-friendly Data Validation in Excel Displaying help out of the way, not on top of your cells in your form.
Thu, 01 Mar 2018 16:00:00 GMT
Come and join us in Amsterdam on June 7 and 8, 2018 for our fifth famous Amsterdam Excel Summit. We have just fixed the dates so make sure you Visit the Amsterdam Excel Summit Website
Tue, 20 Feb 2018 16:40:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved performance of looking for dependents.
Wed, 15 Nov 2017 17:30:00 GMT
Name Manager for Excel has been updated. Fixed an issue caused by a Windows 10 bug. Renaming a name now also fixes hyperlinks using that name
Tue, 31 Oct 2017 10:50:00 GMT
The Excel File Remediation Utility has been updated to build 121. We have improved performance on a number of areas and added a way to report detailed statistics of multiple files.
Mon, 02 Oct 2017 17:05:00 GMT
I have added an add-in to my site called Table Tools. This add-in makes your daily life with Excel tables a little simpler!
Wed, 20 Sep 2017 08:30:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved the formula report
Mon, 18 Sep 2017 15:30:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved performance on analysing conditional formatting formulas
Tue, 15 Aug 2017 13:20:00 GMT
Ik heb vandaag een artikel toegevoegd over Cocreatie in Excel 2016
Thu, 29 Jun 2017 07:00:00 GMT
I have added an article today about co-authoring in Excel 2016
Fri, 23 Jun 2017 16:00:00 GMT
I have added a Windows API function declaration for Office 64 bit to the list: URLDownloadToFile
Thu, 08 Jun 2017 17:15:00 GMT
Updated: Flexfind. Flexfind was updated to build 592 in which I changed the default search scope to just the active workbook.
Wed, 7 Jun 2017 07:05:00 GMT
I have updated my Access Backup utility so it now also orks on 64 bit Access.
Wed, 10 May 2017 08:15:00 GMT
RefTreeAnalyser 2.0 has just been updated. Finally fixed an intermittent issue with the Visualize functionality on Excel 2016
Mon, 08 May 2017 16:20:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved performance for Excel 2013 and 2016
Wed, 26 Apr 2017 14:20:00 GMT
Our Amsterdam Excel Summit has been a great success. We had two very well received days full of Excel and Power BI sessions. Find links to photo impressions on my events page.
Tue, 25 Apr 2017 10:40:00 GMT
Our Excel File Remediation Utility has just been updated. I have added an option to remove all styles from the workbooks. This is very useful if you have Excel files with corrupt styles.
Thu, 23 Mar 2017 15:40:00 GMT
RefTreeAnalyser 2.0 has just been updated. Added jump to pivotsource when you trace precedents when in a pivottable.
Fri, 03 Mar 2017 13:00:00 GMT
RefTreeAnalyser 2.0 has just been updated. Fixed issue regarding range names in formulas.
Sun, 19 Feb 2017 13:20:00 GMT
Updated: Flexfind. Added support for replacing in Powerquery M code (Excel 2016).
Sat, 18 Feb 2017 19:10:00 GMT
RefTreeAnalyser 2.0 has just been updated. Fixed issue with short-cut keys not responding immediately after openening Excel.
Wed, 15 Feb 2017 07:50:00 GMT
RefTreeAnalyser 2.0 has just been updated. I have fixed a bug, Pivottables were not listed when pointing to a table name.
Thu, 9 Feb 2017 09:45:00 GMT
Come and join us in Amsterdam on April 18 and 19 2017 for our famous Amsterdam Excel Summit. We have just opened registration so make sure you book your seats before Feb 20 and receive a nice early-bird discount! Visit the Amsterdam Excel Summit Website
Mon, 16 Jan 2017 16:20:00 GMT
RefTreeAnalyser 2.0 has just been updated. I have improved scrolling the selected cells into the viewable area of the screen
Thu, 5 Jan 2017 06:25:00 GMT
RefTreeAnalyser 2.0 has just been updated. Fixed three bugs.
Wed, 14 Dec 2016 20:55:00 GMT
Name Manager for Excel has been updated. Fix for finding dynamic range names when using the Formulas or 2D areas filter.
Tue, 13 Dec 2016 15:20:00 GMT
Answering questions on forums can be very rewarding. This post is the result of a forum question. The forum member needed a simple system to manage his shop inventory. He wanted to be able to log Purchases, Reservations and Sold items and immediately be kept informed when items are (almost) out of stock..
Tue, 11 Oct 2016 13:15:00 GMT
Excel is a very serious and powerful business application. That doesn't mean we can't have some fun with it. In this article I'll explain how I've built an Excel file which enables you to play with a wheel of fortune. With sound and all!.
Thu, 29 Sep 2016 17:45:00 GMT
A recent Office update may cause your add-ins to be ignored by Excel. This article shows you how to fix that.
Wed, 17 Aug 2016 15:45:00 GMT
I have just updated the small tool which follows your cell pointer by placing two arrows on top of your sheet pointing to the active cell. Fix: enabled for 64 bit Excel.
Mon, 15 Aug 2016 09:00:00 GMT
RefTreeAnalyser 2.0 has just been updated. I have added an option to display your formula as a mathematical equation.
Tue, 21 Jun 2016 14:55:00 GMT
Our All VBA treeview control now has a professional version which is ready for beta testing.
Thu, 16 Jun 2016 15:50:00 GMT
Our All VBA treeview control now has a sister control: the ListGrid. This brand new control is ready for beta testing.
We have just opened registration for The Excel VBA Masterclass. Course dates October 26 and 27, 2016.
Tue, 14 Jun 2016 14:10:00 GMT
Als je (net als ik, voordat ik Excel specialist werd) ingenieur bent, dan heb je waarschijnlijk het nodige aan experimeteerwerk gedaan. Vaak heb je dan een methode nodig om je meetresultaten te fitten met een kromme. En als je een echte ingenieur bent, dan heb je ook al een goed idee wat de soort vergelijking is de theoretisch bij je metingen zou moeten passen.
Tue, 12 Apr 2016 07:50:00 GMT
Ik ben er eindelijk aan toe gekomen een artikel te vertalen. Dit artikel beschrijft een methode om eenvoudig de performance van je VBA routines te meten.
Tue, 17 May 2016 07:50:00 GMT
Updated: Flexfind. Improved selecting objects.
Thu, 21 Apr 2016 08:50:00 GMT
RefTreeAnalyser 2.0 has just been updated. I have improved the off-sheet references report to include tables and range names.
Fri, 8 Apr 2016 15:50:00 GMT
We have just published the course outline of our new training: Excel VBA Masterclass.
Mon, 29 Feb 2016 07:15:00 GMT
RefTreeAnalyser 2.0 has just been updated. Added an off-sheet references report which visualises the inter-sheet formula links of your workbook.
Sat, 27 Feb 2016 15:35:00 GMT
Updated: Flexfind. I have added support for searching and replacing in the first page headers and footers.
Thu, 04 Feb 2016 09:50:00 GMT
RefTreeAnalyser 2.0 has just been updated. I have added an auto-update option.
Tue, 19 Jan 2016 08:25:00 GMT
RefTreeAnalyser 2.0 has just been updated. I fixed a small bug in getting values from entire columns. This is the last update for the Excel 2003 version of the add-in.
Tue, 15 Dec 2015 12:45:00 GMT
RefTreeAnalyser 2.0 has just been updated. I Improved the performance of finding dependents and improved how Objects are listed.
Wed, 25 Nov 2015 11:35:00 GMT
RefTreeAnalyser 2.0 has just been updated. I fixed a small bug causing a runtime error when you close Excel.
Wed, 07 Oct 2015 20:30:00 GMT
With the new MDI interface introduced with Excel 2013, closing all workbooks has become unnecessary difficult. This little addin adds a 'Quit Excel' button to your File menu that will close all open workbooks and quit Excel. It also features a Short-cut key: control+q
Thu, 01 Oct 2015 09:30:00 GMT
To celebrate the fact that Excel was launched 30 years ago (September 30, 1985) we're having an anniversary sale at jkp-ads.com. From September 30 to October 30, 2015 we offer a 30 % discount on both our products: RefTreeAnalyser and The Excel File Remediation Utility
Thu, 01 Oct 2015 08:50:00 GMT
I have just added a chapter to my article on solving startup problems in Excel, especially for the people who are experiencing issues after upgrading their computer to Windows 10
Wed, 16 Sep 2015 13:35:00 GMT
Updated: Flexfind. I have recently fixed a bug in Flexfind where the tool appears to make Excel 2013 unresponsive. The root cause of the problem was the new MDI interface of Excel which forced us to make the Flexfind window the topmost window, thus causing message boxes to appear behind the window in some situations.
Mon, 14 Sep 2015 10:05:00 GMT
Yes we're having a summer sale at jkp-ads.com. From July 1 to July 10 we offer a 25 % discount on both our products: RefTreeAnalyser and The Excel File Remediation Utility
Thu, 25 Jun 2015 06:15:00 GMT
I have launched a product you can try and buy directly from my site: The Excel File Remediation Utility. This tool helps you to try and salvage Excel models with problematic content accumulated during a long editing history.
Excel VBA voor Financials versie 5; Een twee-daagse Excel VBA cursus (6, 14 en 21 oktober 2015). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte!
Mon, 22 Jun 2015 15:45:00 GMT
Vandaag een artikel geplaatst over het maken van een invoegtoepassing in Excel. Alle stappen die je nodig hebt om een eenvoudige invoegtoepassing te maken worden erin beschreven.
Mon, 08 Jun 2015 15:40:00 GMT
RefTreeAnalyser 2.0 has just been updated. I have added support for hotkeys using the Alt key.
Wed, 06 May 2015 17:30:00 GMT
Today I posted an entirely new article. It describes all the steps needed to create a basic Excel add-in.
Mon, 04 May 2015 14:10:00 GMT
Today I posted a link to one of the most comprehensive sets of Excel productivity tools I have ever seen: Andrew's Excel Utilities
Tue, 07 Apr 2015 08:30:00 GMT
Our event is coming real soon now and we're very much looking forward to it. We have outstanding speakers and excellent content, so everything is lined up to make this a superb Excel event. To entice the undecisive Excel lovers to make up their minds and subscribe after all, we decided to make it even more attractive to attend. As of March 27st, 2015 we offer a € 200 last-minute discount per attendee for both days and € 100 for one day! Register now at http://topexcelclass.com/index.php/amsterdam-excel-summit/registration/ and meet us on April 13th and 14th in Amsterdam.
Fri, 27 Mar 2015 08:20:00 GMT
Extended early bird discount on our Amsterdam Excel Summit! Last week our mail server experienced some problems, which meant that the registration form did not work. To compensate for anny inconvenience caused by this problem we have decided to extend the early bird discount period with an additional week. So register before March 1st 2015 and receive the 50 Euro discount!
Mon, 23 Feb 2015 14:40:00 GMT
In my Circular Reference article I promised to include an example of a VBA driven circular reference calculation. I have done that today so head over to my site to check it out!
Wed, 11 Feb 2015 09:30:00 GMT
Join us in Amsterdam on April 13th and 14th 2015, for the second Amsterdam Excel Summit! We have a lot of interesting subjects, including: Business Intelligence in Excel vNext, An introduction to Power Query, working with Excel charts less painful, Professionalising your Power Pivot Model, More efficient VBA UDFs, ...
Tue, 10 Feb 2015 17:20:00 GMT
Name Manager for Excel has been updated. Improved renaming rangenames in VBA code.
Join us in Amsterdam on April 13th and 14th 2015, for the second Amsterdam Excel Summit! An absolute unique group of Excel MVPs will gather in Amsterdam to share their expert knowledge with you. The Excel MVPs happen to be in Amsterdam for a meeting and we've succeeded in getting some of them to present at our event. Make sure you register!
Thu, 22 Jan 2015 10:15:00 GMT
Excel VBA voor Financials versie 2; Een twee-daagse Excel VBA cursus (20 en 26 mei 2015). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte !
Tue, 30 Dec 2014 13:05:00 GMT
Finally got some time to include an Excel 2007-2013 version of this little tool that traces where you went in your Excel files and gets you back easily!
Wed, 19 Nov 2014 06:45:00 GMT
RefTreeAnalyser 2.0 has just been updated. I have added an option to report all unique formulas in your workbook. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Thu, 23 Oct 2014 16:45:00 GMT
Every quarter Microsoft announces who are the lucky ones to receive their Most Valuable Professional Award. I got re-awarded! To celebrate that I am offering a 3 day 50 percent discount on RefTreeAnalyser. From October 8, 2014 to October 10, 2104 you receive 50 % off of the list price when you enter this coupon code: MVP2014 Head over to my website now and download the tool, you can try it for free!
Tue, 07 Oct 2014 09:30:00 GMT
Onze cursus Excel VBA voor Financials blijkt populari. Haast u als u mee wilt doen! Een twee-daagse Excel VBA cursus (19 november en 3 december 2014). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte !
Thu, 02 Oct 2014 16:00:00 GMT
Excel VBA voor Financials; Een twee-daagse Excel VBA cursus (19 november en 3 december 2014). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte !
Mon, 08 Sep 2014 15:35:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved performance of formula checking and added formula block highlighting. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Fri, 20 Jun 2014 15:50:00 GMT
I somehow managed to break the commenting function of my site. Today I fixed it again and you can go ahead and ask your questions or add your comments once more.
Mon, 02 Jun 2014 06:30:00 GMT
My free Flexfind tool for Excel has been updated to build 584. Fixed a bug regarding replacing when search was done in Values.
Thu, 08 May 2014 09:35:00 GMT
Wees er nu echt snel bij, want de registratie sluit al op 7 mei! Op 14 mei 2014 organiseren wij in Amsterdam de eerste "Amsterdam Excel Summit". Een absoluut unieke groep Excel MVPs zal in mei 2014 in Amsterdam zijn om hun geweldige Excel kennis met u te delen. Deze MVPs zijn in Amsterdam voor een bijeenkomst en wij zijn erin geslaagd om deze mensen voor ons evenement te boeken. Er is slechts weinig kans dat een dergelijke mogelijkheid zich nogmaals zal voordoen, dus wees er snel bij als u dit niet wilt missen!
Mon, 28 Apr 2014 10:15:00 GMT
Be quick to join us in Amsterdam on May 14 2014, for the registration on the first Amsterdam Excel Summit closes on May7th! An absolute unique group of Excel MVPs will gather in Amsterdam to share their expert knowledge with you. The Excel MVPs happen to be in Amsterdam for a meeting and we've succeeded in getting some of them to present at our event. There is not much chance on this happening again anytime soon, so make sure you register!
I have added an article to my site, describing a class module to help measuring your VBA performance.
Tue, 15 Apr 2014 17:15:00 GMT
Als je wel eens die vervelende melding hebt gehad over kringverwijzingen toen je een formule maakte of toen je een Excel bestand opende, lees dan dit nieuwe artikel. Excel detecteert een kringverwijzing zodra een reeks formules ertoe leidt dat dezelfde cel meer dan eens in serie berekeningen wordt aangedaan. Veel gebruikers vinden de kringverwijzingen melding uiterst verwarrend en hebben geen idee waardoor die verschijnt. In dit artikel tracht ik het mysterie omtrent deze situatie weg te nemen.
Mon, 14 Apr 2014 11:00:00 GMT
RefTreeAnalyser 2.0 has just been updated. Added hotkeys for Check Formulas and for Objects. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Thu, 03 Apr 2014 16:00:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved reporting and fixed a bug or two. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Mon, 31 Mar 2014 17:30:00 GMT
I have added a page to my article on Slicers, which shows you how to get the selected items of a slicer into a worksheet cell.
Fri, 21 Mar 2014 15:45:00 GMT
I have updated the page on Excel startup problems today with information about a newly discovered tool, the Office Configuration Analyzer Tool (OffCAT).
Thu, 20 Mar 2014 16:15:00 GMT
I have added a page to my article on Slicers, which shows you how to synchronise slicers which drive different PivotCaches.
Thu, 13 Mar 2014 17:15:00 GMT
Op 14 mei 2014 organiseren wij in Amsterdam de eerste "Amsterdam Excel Summit". Een absoluut unieke groep Excel MVPs zal in mei 2014 in Amsterdam zijn om hun geweldige Excel kennis met u te delen. Deze MVPs zijn in Amsterdam voor een bijeenkomst en wij zijn erin geslaagd om deze mensen voor ons evenement te boeken. Er is slechts weinig kans dat een dergelijke mogelijkheid zich nogmaals zal voordoen, dus wees er snel bij als u dit niet wilt missen!
Thu, 13 Feb 2014 15:40:00 GMT
Join us in Amsterdam on May 14 2014, for the first Amsterdam Excel Summit. An absolute unique group of Excel MVPs will gather in Amsterdam to share their expert knowledge with you. The Excel MVPs happen to be in Amsterdam for a meeting and we've succeeded in getting some of them to present at our event. There is not much chance on this happening again anytime soon, so make sure you register!
RefTreeAnalyser 2.0 has just been updated. Prevented opening of unneeded blank workbook. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Fri, 24 Jan 2014 13:40:00 GMT
RefTreeAnalyser 2.0 has just been updated. Made searching in Objects optional for searching precedents and dependents to improve performance. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
RefTreeAnalyser 2.0 has just been updated. Fixed a small bug introduced with searching in Objects. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Wed, 22 Jan 2014 14:10:00 GMT
RefTreeAnalyser 2.0 has just been updated. Now if you're tracing precedents or dependents objects (such as pivot tables, charts, data validation, Conditional formatting, ...) are also traced for cell dependencies. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Tue, 14 Jan 2014 08:20:00 GMT
RefTreeAnalyser 2.0 has just been updated. Now you can analyse all your Excel objects (such as pivot tables, charts, data validation, Conditional formatting, ...) for cell dependencies. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Tue, 07 Jan 2014 17:00:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved placement of pictures of far-away cells. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Wed, 06 Nov 2013 12:30:00 GMT
RefTreeAnalyser 2.0 has just been updated. Visualisation colors can now be changed. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Fri, 01 Nov 2013 16:15:00 GMT
RefTreeAnalyser 2.0 has just been updated. Visualize precedents has been made available for Excel 2003 too. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Wed, 30 Oct 2013 12:35:00 GMT
RefTreeAnalyser 2.0 has just been updated. Added a new option to the tool: Visualize precedents. The precedents of a cell are visualised directly on the worksheet, a vast improvement on the built-in show precedents option. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Wed, 23 Oct 2013 16:15:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved the reporting function. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Thu, 17 Oct 2013 16:10:00 GMT
My free Flexfind tool for Excel has been updated to build 581. It now handles replacement of dates better.
Tue, 15 Oct 2013 15:25:00 GMT
I have just published a tool today, Trusted Documents Manager. This little tool enables you to manage your list of trusted documents. Currently, Excel only allows you to either leave the list intact, or delete the entire list. This means all of your currently trusted documents become untrusted again so you have to enable macro's on all of them once again. The tool allows you to remove just one file, remove an entire folder or even an entire drive. Also it offers to possibility to remove files which no longer exist from the list.
Thu, 10 Oct 2013 13:30:00 GMT
Our All VBA treeview control for Office has been updated to build 025. We've added a ControlTipText property and fixed a small bug regarding scrolling horizontally when checking a node.
Wed, 02 Oct 2013 12:15:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved tracing errors function. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Wed, 02 Oct 2013 09:15:00 GMT
RefTreeAnalyser 2.0 has just been updated. Small bugfix regarding handling of windows in Excel 2013. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Mon, 30 Sep 2013 10:30:00 GMT
RefTreeAnalyser 2.0 has just been updated. Important update: fixed some bugs in the multi-level precedents searching. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Wed, 25 Sep 2013 10:45:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved the error tracing and fixed a problem with the Stop button. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Mon, 23 Sep 2013 09:05:00 GMT
RefTreeAnalyser 2.0 has just been updated. Fixed a bug for Excel 2013 (another messagebox was hidden from view by the appl. interface). Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Fri, 20 Sep 2013 13:30:00 GMT
The previous solution I developed for this problem had a serious drawback: messageboxes would show behind the userform. This new solution is simpler and does not have that problem.
Name Manager for Excel has been updated. Improved window handling for Excel 2013.
Mon, 09 Sep 2013 17:30:00 GMT
RefTreeAnalyser 2.0 has just been updated. Fixed a bug for Excel 2013 (messageboxes are hidden from view by the appl. interface). Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Wed, 28 Aug 2013 11:30:00 GMT
Name Manager for Excel has been updated. Added Italian user interface language.
Wed, 21 Aug 2013 16:10:00 GMT
RefTreeAnalyser 2.0 has just been updated. Improved returning to the original selection after closing the tool. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Fri, 07 Jun 2013 13:00:00 GMT
RefTreeAnalyser 2.0 has just been updated. Fixed some minor issues regarding use in Excel 2003. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Sun, 26 May 2013 10:20:00 GMT
Our All VBA treeview control for Office has been updated to build 024. We have now included properly working examples for Word and Access!
Mon, 20 May 2013 14:10:00 GMT
RefTreeAnalyser 2.0 has just been updated. Now you can change the hotkeys. People who are using version 2 will be automatically prompted for this update. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Fri, 03 May 2013 14:00:00 GMT
Anyone who places an order between April 30, 2013, 8:00 AM GMT and May 1st, 2013 8:00 AM GMT will receive a 50 % rebate on the list price. I'm also going to give away some of the licenses: I'll randomly select 1 out of every 10 orders placed in that period of time These people will receive a complimentary license.
Mon, 29 Apr 2013 19:40:00 GMT
Koninginnedag uitverkoop! Alle bestellingen geplaatst tussen 30 april 10:00 's morgens en 1 mei 10:00 uur 's morgens (Nederlandse zomertijd) krijgen 50 procent korting. Bovendien verloot ik een gratis licentie per 10 geplaatste bestellingen.
RefTreeAnalyser has been completely updated to version 2.0. This new version also works on the 64 bit versions of Office. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Wed, 24 Apr 2013 16:25:00 GMT
Our All VBA treeview control for Office has been updated to build 021.
Thu, 14 Mar 2013 13:10:00 GMT
We have created a treeview for Office VBA that will work on any version of Office as of Office 2000, including 64 bits and MAC Office! If you have ever used the Treeview control from the "Additional controls" section, then you know what a versatile control this is to show hierarchically organized data. There are a couple of problems with this Treeview control: You risk compile errors and -worse- it will not work on 64 bit Office..
Thu, 21 Feb 2013 14:30:00 GMT
I've updated Autosafe with new translations for German.
Tue, 29 Jan 2013 15:30:00 GMT
RefTreeAnalyser has been updated. I have changed how hidden sheets are handled (no more messageboxes). Do you have a license? Then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Wed, 02 Jan 2013 14:05:00 GMT
With the introduction of Excel 2013, Microsoft changed the windowing of Excel. On all previous versions, Excel had a so-called Multiple Document Interface (MDI), which means all open Excel files are hosted by one Excel application window. Excel 2013 introduced a Single Document Interface, meaning each workbook appears in its own Excel window. This new feature of Excel causes some trouble with modeless userforms. This article shows you how to resolve the issues involved.
Mon, 26 Nov 2012 14:45:00 GMT
My free Flexfind tool for Excel has been updated to build 577. It now properly keeps its dialog on top of all Excel 2013 windows.
Wed, 21 Nov 2012 14:55:00 GMT
My free Flexfind tool for Excel has been updated to build 575. Fixed a problem with searching in Forumlas in non-English versions of Excxel.
Tue, 13 Nov 2012 16:35:00 GMT
Name Manager for Excel has been updated. Fixed a small issue with regards to updating the LinkedCell property when renaming.
Thu, 21 Jun 2012 06:20:00 GMT
I have added my control lister to my download page today, this tool lists all controls on your userforms on a worksheet. Includes code to rebuild the userforms from the table.
Thu, 14 Jun 2012 16:30:00 GMT
I have added a couple of new Windows API function declarations for Office 64 bit to the list.
Wed, 06 Jun 2012 18:45:00 GMT
Name Manager for Excel has been updated. Fixed a small issue with regards to replacing rangenames in VBA code. Now it also handles range names in square brackets such as [TheName].
Mon, 4 Jun 2012 08:20:00 GMT
If you've ever experienced the "Circular reference warning" popping up when you opened an Excel file read this new article. Excel detects a circular reference when a chain of calculations visits the same cell more than once. Many users get (very) confused by this message and have no idea what it is about. I'll try to demystify that message here!
Wed, 02 May 2012 15:30:00 GMT
If you're an engineer (like I used to be in a previous life), you have probably done your bit of experimenting. Usually, you then need a way to fit your measurement results with a curve. If you're a proper engineer, you also have some idea what type of equation should theoretically fit your data. Excel provides us with a couple of tools to perform Least Squares calculations, but they are all centered around the simpler functions: simple Linear functions of the shape y=a.x+b, y-a.exp(b.x), y=a.x^b and etcetera. What if you want to fit a more complex function, like y=exp(a.x).sin(x) + b ? How can that be done using Excel? This article shows a way to do this.
Thu, 12 Apr 2012 15:25:00 GMT
RefTreeAnalyser has been updated. I have fixed a bug in the reporting option of the tool. Do you have a license? Then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Thu, 29 Mar 2012 13:05:00 GMT
RefTreeAnalyser has been updated. I have fixed a tiny bug which caused the tool to generate a runtime error when you close Excel without any open workbooks. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Tue, 14 Feb 2012 15:25:00 GMT
My free Flexfind tool for Excel has been updated to build 574. Excel 2010 caused problems with searching for the category Axis title.
Fri, 10 Feb 2012 08:35:00 GMT
RefTreeAnalyser has been updated. I have fixed a bug regarding hidden worksheets, which could cause the tool to generate runtime errors. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Thu, 26 Jan 2012 06:55:00 GMT
Met het op de markt komen van Excel 2010, heeft Microsoft ook de mogelijkheid geintroduceerd om Excel documenten on-line te bewerken, gebruik makend van de "Excel Web App". Indien je een Live account hebt, kan je een Excel 2010 bestand plaatsen op je skydrive. Iedereen die toegang heeft tot die Skydrive map, kan vervolgens dat Excel bestand on-line openen en in de browser berwerken. Tevens is het mogelijk om dat Excel bestand te integreren op iedere web pagina.
Thu, 05 Jan 2012 10:25:00 GMT
With Excel 2010, Microsoft introduced the possibility to edit Excel documents on-line, using the "Excel Web App". If you have a live account, you can place an Excel 2010 file on your skydrive. Anyone who has access to that skydrive folder can then open that Excel file on-line and edit it in the browser. Moreover, you can also embed that same Excel file on any web page.
Thu, 15 Dec 2011 10:25:00 GMT
I have updated my article that describes how to use Setup Factory to install an addin. Special thanks to Emiel Nijhuis of www.delegate.nl for suggesting some fixes.
Tue, 22 Nov 2011 06:40:00 GMT
Name Manager for Excel has been updated. Fixed a small issue with regards to replacing rangenames in VBA code.
Mon, 26 Sep 2011 12:45:00 GMT
This utility enables you to copy the components from a VBAProject to a single text file. Very useful if you need to compare the VBA code of two Excel files. Use a text compare tool like ExamDiff to compare differences in the exported files.
Thu, 15 Sep 2011 15:45:00 GMT
Met deze utility kan je alle VBA componenten van werkmap A exporteren naar één tekst bestand. Handig als je de inhoud van twee versies van een VBA project wil vergelijken.
I've updated Autosafe so it now also works in 64 bit Excel 2010.
Mon, 29 Aug 2011 11:00:00 GMT
I have added an article to my website (courtesy Niek Otten). Introduction of the article: Sometimes you want to apply an existing worksheet calculation to many sets of data rather than just the one case for which it was designed. For example, you developed a worksheet which calculates your pension. It accepts some twenty input variables and generates five output variables. Then your boss demands that you apply that one-time worksheet to 500 employees. Of course you could write some VBA code to do this. But many people hesitate to use VBA and often they are not even allowed to, on their work PC. Fortunately, there is a solution that does not require VBA. Excel has a feature for doing this, the Data, Table command. But it's not well documented. Each time I was asked to do something complex using a Data Table, it took me a while to remember how to do it. So I developed this recipe. It may seem like a lot of steps, but it's actually very straightforward and can be done in minutes.
Thu, 25 Aug 2011 13:05:00 GMT
Name Manager for Excel has been updated. Fixed a small issue with regards to the larger grid in Excel 2007 and 2010.
Thu, 07 Jul 2011 13:05:00 GMT
I have added a link to a download by Microsoft listing many win64 API declarations.
Thu, 12 May 2011 09:05:00 GMT
Thu, 03 Mar 2011 07:15:00 GMT
My free Flexfind tool for Excel has been updated to build 570. Flexfind now also works in 64 bit Excel 2010.
Thu, 17 Feb 2011 07:45:00 GMT
Name Manager for Excel has been updated. When deleting a name, Name Manager now offers to un-apply the name in your workbook.
Tue, 15 Feb 2011 16:45:00 GMT
Name Manager for Excel is bijgewerkt. Bij verwijderen van bereiknamen worden deze nu op verzoek in je formules omgezet naar hun oorspronkelijke verwijzingen.
My free Flexfind tool for Excel has been updated to build 569. Flexfind now finds Error values like #NUM! if your Excel is NOT in English.
Mon, 14 Feb 2011 07:45:00 GMT
Pivottables are one of the most powerful data analysis features Excel has to offer. From version to version, Microsoft have added functionality to this feature. The number of additions and their usefulness differ from version to version of course. Amongst the additions and updates for Excel 2010 are Pivottable Slicers. In this article I'll discuss how you can put slicers to work.
Wed, 12 Jan 2011 13:45:00 GMT
Sometimes I review a piece of software. I decided these deserve a special place on my website, so here is the first one: Setup Factory.
Mon, 03 Jan 2011 07:45:00 GMT
My free Flexfind tool for Excel has been updated to build 568. Flexfind can now handle characters like alt+010.
Tue, 14 Dec 2010 06:35:00 GMT
Name Manager for Excel has been updated. Fixed a compile error Office 2010 64 bit users were experiencing.
Tue, 23 Nov 2010 08:45:00 GMT
Name Manager for Excel has been updated. I finally fixed an odd compile error that only happened for a few of my users.
Thu, 18 Nov 2010 05:25:00 GMT
I have finally gotten round to updating the Query Manager so you can use it to update the connection and commandtext of pivot caches using external data.
Thu, 23 Sep 2010 09:20:00 GMT
I have just published a small tool which follows your cell pointer by placing two arrows on top of your sheet pointing to the active cell. Does not change your cell formatting.
Wed, 08 Sep 2010 15:50:00 GMT
Ik heb zojuist een tooltje geplaatst, dat je cel aanwijzer makkelijker te vinden maakt door er met een horizontale en vertikale pijl naar te wijzen.
Seems the methods I described to prevent the workbook_Open event do not always work for Excel 2007.
Thu, 08 Jul 2010 20:00:00 GMT
Name Manager for Excel has been updated to version 4.2 with quite a number of updates.
Thu, 01 Apr 2010 17:50:00 GMT
Name Manager voor Excel, versie 4.2 is gepubliceerd, met aardig wat nieuwe mogelijkheden.
My free Name Manager for Excel has been updated to build 616 so it now works on 64 bit Excel 2010 too. This means there is a version of Name Manager for all versions of Excel, starting with Excel 97.
Thu, 01 Apr 2010 07:20:00 GMT
De pagina is bijgewerkt voor de Excel versies 2007 en 2010.
Mon, 22 Mar 2010 08:40:00 GMT
If you've ever tried to open a text file, you have probably used the Text import wizard. If you have ever opened a CSV file, you have probably noted you can't set up how it gets imported. The text import wizard does not start for these file types. What if you have the situation where you get files with similar structure, which need the same text import settings over and over? How do you import the data from those files into the same worksheet each time, without having to re-define the import settings over and over again? I'll tell you.
Thu, 11 Mar 2010 09:00:00 GMT
I have updated my Access Backup utility so it no longer errors on linked tables. Also, it now copies the relationships too.
Wed, 03 Feb 2010 09:45:00 GMT
With the introduction of Windows 7 and Office 2010 VBA developers face a new challenge: ensuring their applications work on both 32 bit and 64 bit platforms. This page is meant to become the first stop for anyone who needs the proper syntax for his API declaration statement in Office VBA.
Thu, 28 Jan 2010 12:05:00 GMT
Omdat ik software ontwikkelaar ben, komt het regelmatig voor dat ik een Excel bestand wil openen met de macro's ingeschakeld. Tegelijkertijd wil ik daarbij soms voorkomen dat het Workbook_Open event of de Auto_Open macro wordt uitgevoerd. In dit artikel laat ik zien hoe dit in de verschillende Excel versies kan worden gedaan.
Mon, 11 Jan 2010 08:20:00 GMT
To enable showing argument descriptions for Excel User Defined Functions (UDF), we had to go through many hoops and use wizardry and trickery. Excel 2010 has now enabled us to use a plain and simple VBA command to do exactly that. I have updated the article to include a how-to for Excel 2010.
Wed, 06 Jan 2010 06:40:00 GMT
Apart from input cells chained to cells with formulas, there are other options in Excel to make your spreadsheet model more interactive. You can add option buttons, check boxes and list boxes to your sheet to offer choices to the user. Moreover, you can add scroll bars and spinners to quickly control values in cells. These elements are called controls because they enable your user to control the content of your model. This article shows how to put controls to use in your model.
Tue, 29 Dec 2009 09:15:00 GMT
As a fulltime developer I oftentimes open files containing VBA and want to be able to run code. At the same time I sometimes want to prevent Workbook_Open event code or an Auto_Open macro from running. This little article shows you how to achieve that.
Mon, 07 Dec 2009 13:20:00 GMT
Naast invoercellen die zijn gekoppeld aan cellen met formules, beschikt Excel over nog meer mogelijkheden om een werkblad interactief te maken. Zo is het mogelijk om aan een werkblad keuzerondjes, selectievakjes, tekstvakjes en dergelijke toe te voegen. Deze elementen worden ook wel besturingselementen genoemd, omdat ze de gebruiker in staat stellen Excel te "besturen". Dit artikel laat zien hoe deze elementen gebruikt kunnen worden.
Mon, 23 Nov 2009 13:10:00 GMT
My free Flexfind tool for Excel has been updated to build 563. Flexfind can now handle textboxes with more than 255 characters of text.
Tue, 17 Nov 2009 06:35:00 GMT
RefTreeAnalyser has been updated. RefTreeAnalyser now does not error out when started whilst editing a cell.
Thu, 05 Nov 2009 10:40:00 GMT
RefTreeAnalyser has been updated. It now shows a small message when no references have been found.
Fri, 02 Oct 2009 15:30:00 GMT
My free Name Manager for Excel has been updated to build 613, with a bugfix related to Excel 2010.
Wed, 30 Sep 2009 15:00:00 GMT
My free Name Manager for Excel has been updated to build 610. I have added the possibility to add local names to each worksheet using the Add Names dialog. In addition, Name Manager is now fully Excel 2010 compatible!
Wed, 22 Jul 2009 13:30:00 GMT
RefTreeAnalyser has been updated to fix a small bug related to using the stop button.
Fri, 17 Jul 2009 14:55:00 GMT
My free Name Manager for Excel has been updated to build 608. Fixed some minor bugs.
Mon, 13 Jul 2009 07:10:00 GMT
Excel provides a very useful option to gather data from websites, called web queries. These have been introduced with Excel 97 and have been further enhanced in the versions released after Excel 97. This article shows how you can setup a web query so that you can make the worksheet dynamically update based on the values in so called parameter cells.
Thu, 09 Jul 2009 08:30:00 GMT
I've updated Autosafe so it stays quiet as long as the system has been used within the last 30 seconds. After 4 skips it will do a save even though you're busy.
Mon, 25 May 2009 08:10:00 GMT
Previously, I showed how to access and modify existing parts of an Office OpenXML package. This opens up the path for us to add ribbon customisation code to an Office file. For this to happen, a couple of modifications were needed to the code in the class module I showed earlier. Fellow Excel MVP Ken Puls was kind enough to make some modifications to the class module, which I refined a little. The results are summarised in this article.
Mon, 18 May 2009 18:30:00 GMT
Wouldn't it be useful to be able to edit the contents of an Office 2007 OpenXML file from within VBA? Well, now you can, using the sample code and explanation in this article.
Wed, 06 May 2009 18:00:00 GMT
RefTreeAnalyser has been updated to fix a small bug related to protected worksheets.
Mon, 04 May 2009 06:25:00 GMT
Excel 2007 is de eerste Excel versie in lange tijd die vele vernieuwingen bevat. Eén daarvan is de verbetering in de manier waarop Excel om kan gaan met gegevens tabellen. De functionaliteit (Tabellen genaamd) is in wezen een uitbreiding op de lijsten die Excel 2003 al kent. Dit artikel introduceert deze nieuwe functionaliteit en laat zien hoe het u kan helpen in uw dagelijks werk met Excel.
Tue, 28 Apr 2009 08:10:00 GMT
Excel heeft honderden ingebouwde functies die je helpen bij het doen van allerlei berekeningen. Maar soms is het handiger om een zelfgemaakte functie te bouwen in VBA. Dergelijke functies worden ook wel "User Defined Function" genoemd, UDF. UDF's worden normaal gesproken hetzij in het bestand gezet waarin ze nodig zijn, hetzij in een invoegtoepassing. Er kunnen problemen ontstaan wanneer de lokatie van de invoegtoepassing wordt veranderd, bijvoorbeeld omdat deze in de lokale addin map is geplaatst (deze map is voor iedere gebruiker anders!). Zodra een bestand geopend wordt dat gebruik maakt van de UDF op een systeem met een afwijkend pad naar de invoegtoepassing, zullen de formules die een functie uit de invoegtoepassing gebruiken als resultaat #NAAM! geven. In dit artikel beschijf ik een aantal manieren om deze problemen het hoofd te bieden.
Fri, 24 Apr 2009 11:00:00 GMT
Excel 2007 (Office 2007) heeft een nieuw bestandsformaat, gebaseerd op wat Microsoft het Open XML formaat noemt. Dit nieuwe formaat geeft ons de mogelijkheid om programmacode te schrijven, die Office 2007 bestanden kan genereren en/of wijzigen, zonder dat Office daarvoor hoeft te zijn geinstalleerd. Bijvoorbeeld op een (web-)server. Alhoewel er behoorlijke documentatie is over dit bestandsformaat, beslaat dit document met de gedetailleerde beschrijvingen van het Open XML formaat ("part 4" op de vermelde pagina) maar liefst 4721 paginas ! Daarom besloot ik een paar basis pagina's te schrijven over hoe men iets met deze Open XML bestanden kan doen.
Wed, 22 Apr 2009 08:15:00 GMT
RefTreeAnalyser has been updated with a new feature: The tool now handles Excel 2007 structured references to tables. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Mon, 30 Mar 2009 15:15:00 GMT
RefTreeAnalyser is bijgewerkt met een kleine toevoeging: de tool toont nu ook gestructureerde verwijzingen naar Excel 2007 tabellen. Heeft u een licentie? Haal dan deze gratis update op! Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan weet u wat een nachtmerrie dat kan zijn! Nu is er de RefTreeAnalyser! Met deze tool is het uiterst eenvoudig om erachter te komen hoe een cel aan haar informatie komt en welke andere cellen hun waarde aan deze cel ontlenen.
My free Name Manager for Excel has been updated to build 606. No bug fixes, just added the Finnish language.
Sun, 22 Feb 2009 11:30:00 GMT
I've added some information on solving Excel trouble caused by corruptions in Excel's registry key.
Wed, 18 Feb 2009 11:50:00 GMT
De pagina is bijgewerkt met nieuwe informatie over het oplossen van een register probleem van Excel.
This article explains how you can use styles to ease maintenance of your spreadsheet models. Microsoft has made it very easy to dress up your worksheets with all sorts of fill patterns, borders and other frills. Because formatting of cells is often done in an ad-hoc manner, many spreadsheet pages look messy. By consistently using cell styles you will be forced to think about the structure of your work. Religiously using styles may even force people to reconsider the overall structure of the entire spreadsheet model: The quality of the computational model itself may be positively affected. I therefore consider Styles as being underused, underestimated and under exposed.
Thu, 05 Feb 2009 16:30:00 GMT
RefTreeAnalyser has been updated with a new feature: The tool now shows the trace arrows of the currently selected cell. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Thu, 29 Jan 2009 08:25:00 GMT
RefTreeAnalyser is bijgewerkt met een kleine toevoeging: de tool toont de verwijzingspijlen van de huidige geselecteerde cel. Heeft u een licentie? Haal dan deze gratis update op! Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan weet u wat een nachtmerrie dat kan zijn! Nu is er de RefTreeAnalyser! Met deze tool is het uiterst eenvoudig om erachter te komen hoe een cel aan haar informatie komt en welke andere cellen hun waarde aan deze cel ontlenen.
Dit artikel laat zien hoe je gebruik kunt maken van Excel's stijlen om het onderhoud aan een spreadsheet te vergemakkelijken. Het is maar al te gemakkelijk om een werkblad te verfraaien met allerlei kleurtjes, kadertjes en andere tierelantijntjes. Omdat deze formatterings werkzaamheden vaak ad-hoc gebeuren, veroorzaakt dit nogal eens een rommelig geheel. Door consistent gebruik te maken van opmaak profielen in plaats van cel voor cel onderdelen van de formattering aan te passen, wordt je gedwongen gestructureerder te werken. Dit artikel laat zien hoe e.e.a. in zijn werk gaat.
Thu, 29 Jan 2009 07:30:00 GMT
I've updated Autosafe to cater for illegal filenames which may result from downloading files. Please note that if you're using build 119, the autoupdate function causes an error. 119 users are advised to download autosafe manually:
Mon, 26 Jan 2009 17:40:00 GMT
Laatst had ik in een project een snelle methode nodig om de inhoud van een matrix aan de gebruiker te tonen. Ik wilde hiervoor geen werkblad gebruiken, maar koos voor een Userform. Dus bedacht ik dat ik een listbox wilde gebruiken waarvan de kolombreedtes zich aan de gegevens zouden aanpassen. Dat bleek helemaal zo eenvoudig nog niet...
Mon, 19 Jan 2009 18:00:00 GMT
My very first Access tool has been published today: Do you have one or more databases which are permanently in use? Then you probably know you can't just copy their files to create a backup of them as they might become corrupt. This database tool lets you schedule backups for an unlimited amount of Access databases. The tool keeps three backup copies of each database it backs up. Access 2000 and up.
Thu, 18 Dec 2008 13:05:00 GMT
Heeft u een of meer databases die permanent in gebruik zijn? Dan weet u wellicht, dat u niet zonder meer een backup van deze bestanden kunt maken terwijl ze in gebruik zijn: de kopien kunnen corrupt zijn. Deze database tool geeft de mogelijkheid om een ongelimiteerd aantal databases in een in te stellen frequentie te laten kopieren. De tool houdt drie versies van elke database in stand, voor extra zekerheid.
I've updated Autosafe to fix a small bug in the update process that affected Excel 2007.
Thu, 27 Nov 2008 08:05:00 GMT
Microsoft Office 2003 Professional was the first Office version that took the XML standard seriously. The XML standard has been devised to ease the markup of data (especially on the web). A well known example of the use of XML are RSS feeds with which one can gather news from web pages. In reality, these so-called RSS-feeds are nothing less than XML files. This article introduces XML and shows some things that can be done with it (specifically in Excel).
Thu, 20 Nov 2008 14:25:00 GMT
I've updated Autosafe to include the Korean language and fixed a small bug that made Autosafe pickup backup copies of other Excel sessions.
Wed, 12 Nov 2008 06:05:00 GMT
Already 5 years have passed since I founded my company. And I must say those years passed in the blink of an eye. I've never enjoyed my work as much as in these past years. Along with this fifth anniversary comes a new website look and feel. Come and have a look!!
Wed, 05 Nov 2008 19:15:00 GMT
RefTreeAnalyser has been updated a minor bugfix regarding screen resizing. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Mon, 20 Oct 2008 12:10:00 GMT
RefTreeAnalyser is bijgewerkt met een kleine bugfix met betrekking tot het veranderen van de schermgrootte. Heeft u een licentie? Haal dan deze gratis update op! Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan weet u wat een nachtmerrie dat kan zijn! Nu is er de RefTreeAnalyser! Met deze tool is het uiterst eenvoudig om erachter te komen hoe een cel aan haar informatie komt en welke andere cellen hun waarde aan deze cel ontlenen.
RefTreeAnalyser has been updated a minor bugfix regarding duplicate operators in formulas such as >=. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Thu, 25 Sep 2008 18:44:00 GMT
My free Name Manager for Excel has been updated to build 604. A tiny issue was fixed.
Wed, 17 Sep 2008 11:10:00 GMT
My free Flexfind tool for Excel has been updated to build 560. I've fixed a bug in searching and replacing in chart series.
Mon, 11 Aug 2008 18:45:00 GMT
Excel has a host of built-in functions to help you do your computations. But sometimes you need to write your own functions using VBA. These functions are called "User Defined Functions" (UDF). UDFs typically are placed in addins. As long as the addin is installed, the UDFs work as expected. You get into trouble when the location of the addin changes, for example because you have distributed the Addin to your co-workers and they have installed it to their local user addin folder (which is different for each user!). As soon as a file which uses the UDF is opened on a system that uses a different addin path, all cells that use your UDF show #NAME! errors. Also, the complete path to the original location of the add-in is shown in each formula: ='C:\data\FixLink2UDF.xla'!UDFDemo(A1,A2). This article describes a couple of ways to avoid/resolve this situation.
Mon, 02 Jun 2008 18:15:00 GMT
For a project I needed a quick way to display the content of an array to the user. I didn't want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. So I figured I'd put a listbox on a userform and make sure the column widths of the listbox resize with the data I want shown. That proved far from easy...
Wed, 14 May 2008 18:15:00 GMT
Updated Name Manager: Fixed a bug: when hidden name is edited, it used to become unhidden. When one adds names and the filter is set to show hidden names, new names are hidden by default.
Tue, 13 May 2008 18:45:00 GMT
Updated Name Manager: Fixed a bug in the used names filter avoiding false positives on names which resemble a column reference.
Tue, 13 May 2008 08:00:00 GMT
Updated SetupUtility: Accounted for the fact the Application.UserLibraryPath does contain a trailing pathseparator, unlike any other path in Excel's object model.
Tue, 06 May 2008 10:55:00 GMT
Updated Name Manager: Fixed a bug in the Areas filter.
Wed, 23 Apr 2008 15:45:00 GMT
My free Flexfind tool for Excel has been updated to version 5.3, build 558. I've improved the UI and the selecting of found items.
Fri, 28 Mar 2008 13:45:00 GMT
Updated Name Manager: I've Updated the unused names filter to include objects and VBA and fixed a bug affecting Excel 2000 users only.
RefTreeAnalyser has been updated with hotkeys and improved reporting. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Mon, 10 Mar 2008 08:10:00 GMT
Updated Name Manager: Fixed a bug regarding editing a name in R1C1 mode and changed the way the create name dialog works.
Wed, 13 Feb 2008 18:15:00 GMT
RefTreeAnalyser has been updated with a help file and is now accessible through the cell rightclick menu. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Wed, 13 Feb 2008 06:10:00 GMT
Updated Name Manager: Removed a control on a form that caused compile errors for some users.
Fri, 18 Jan 2008 19:25:00 GMT
You know the situation: You have carefully setup a workbook with intricate Validation schemes. But then along comes your user and he copies and pastes at will. Result: Validation zapped, workbook structure violated. What to do? The only way I find reliable is to catch all possible paste operations. But this isn't very easy, since there are a zilion ways to paste...
Mon, 17 Dec 2007 18:10:00 GMT
Now in one convenient place: the most recent references to articles from what I think are the most important Excel Blogs in the world.
Fri, 07 Dec 2007 18:10:00 GMT
Updated Name Manager to add a tiny but very useful toolbar to the VBE, which enables you to select from available range names and paste into your code.
Thu, 06 Dec 2007 18:00:00 GMT
De Name Manager is uitgebreid met een o zo handig toolbartje waarmee je in de Visual Basic Editor een bereiknaam kunt selecteren in in je code laten plakken.
Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Mon, 03 Dec 2007 10:55:00 GMT
Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan weet u wat een nachtmerrie dat kan zijn.! Nu is er de RefTreeAnalyser! Met deze tool is het uiterst eenvoudig om erachter te komen hoe een cel aan haar informatie komt en welke andere cellen hun waarde aan deze cel ontlenen.
I just learnt that using a table from workbook 1 in workbook 2 requires a special syntax. I have updated the article so it includes this information.
Wed, 14 Nov 2007 07:35:00 GMT
My free Flexfind tool for Excel has been updated to build 552. Fixed problems with using wildcard search and replace.
Mon, 08 Oct 2007 14:15:00 GMT
Dit artikel is onlangs (in het Nederlands) geplaatst op de website "Microsoft voor ondernemers". De link naar het artikel op de Microsoft site vindt u op bij het artikel op mijn site.
Fri, 28 Sep 2007 10:37:00 GMT
This article of mine was recently published (in Dutch of course) on the Dutch Microsoft website. The link to the MSFT site is mentioned at the top of the article.
Updated Name Manager to fix a small bug. Now pivot table source ranges are updated when renaming a name.
Tue, 18 Sep 2007 07:00:00 GMT
Name Manager is bijgewerkt naar build 588 waarmee een kleine bug is gefixt. Nu worden de bronbereiken van draaitabellen ook aangepast bij het hernoemen van een bereiknaam.
This utility enables you to copy the components from the VBAProject of workbook A to Workbook B. Updated to build 005: Fixed not copying class modules.
Tue, 11 Sep 2007 15:45:00 GMT
My free Flexfind tool for Excel has been updated to build 551. Fixed some problems with searching in protected worksheets.
Wed, 08 Aug 2007 17:30:00 GMT
This utility enables you to copy the components from the VBAProject of workbook A to Workbook B. Updated to build 004: Existing modules are overwritten in stead of added.
Mon, 06 Aug 2007 17:05:00 GMT
My free AutosafeVBE for Excel has been updated to build 026. Important fixes for the Excel version are included, so users are recommended to download.
Mon, 06 Aug 2007 07:35:00 GMT
On this page I explain how you can change properties of form controls on worksheets by editing the xml inside an Excel file's internals directly.
Fri, 08 Jun 2007 18:25:00 GMT
This utility enables you to copy the components from the VBAProject of workbook A to Workbook B.
Fri, 01 Jun 2007 18:25:00 GMT
My free Flexfind tool for Excel has been updated to build 550. Important fix: When replacing text in Values, previous builds would also replace in cells with a formula. Build 550 fixes that issue.
Thu, 31 May 2007 09:15:00 GMT
On this new page I'll explain how you can read and write to a cell on a worksheet by editing the xml inside an Excel file's internals directly.
Thu, 17 May 2007 15:15:00 GMT
If you do some VBA programming regularly, you'll be acquainted with the Object browser, which neatly shows you all objects, properties and methods belonging to any object in Excel (or any other library you have referenced in your VBA project). Whilst this is a tremendous tool to look for information on just a couple of properties I find it not very handy when you e.g. Need to get all of an objects properties into your VBA code. So because I like a challenge I decided to build my own object browser, which is shown to you on this new page.
Mon, 14 May 2007 14:00:00 GMT
In "Working with Tables in Excel 2007" I promised to add a page about working with those tables in VBA too. Well, here you go.
Fri, 27 Apr 2007 18:45:00 GMT
I have updated this article because I got some reports on problems with Excel 2007.
Mon, 23 Apr 2007 10:20:00 GMT
Sometimes I want to automate the editing of some parts of my VBA code. One thing I wantd to do lately, was search for mutliple of lines of codes (and of course replace them with new lines). I've now released a tool that enables you to do just that!
Thu, 12 Apr 2007 15:30:00 GMT
Since I revised an Excel VBA book, I decided it was time to add a page on books on Excel to my website. The page only lists this one book for now, but I intend to add more in the coming weeks.
Tue, 03 Apr 2007 08:30:00 GMT
This article first shows how Excel manages addins in the registry. Then it shows scripts how to do this during a setup routine using the program called Setup Factory. Being an MVP has some benefits. One of them is that some software companies offer Not For Resale (NFR) products to them for free. Of course these companies hope the MVPs will advocate their products. Well, for this one I will do so: Setup Factory. I've started using this tool just a week ago and I must say I'm most impressed with it.
Wed, 21 Mar 2007 09:10:00 GMT
I've updated Autosafe to include the 'updating of an addin' method I described earlier.
Tue, 20 Mar 2007 13:10:00 GMT
If you have created a nice add-in, an updating mechanism is an easy way to ensure your users get any bugfixes you did automatically . This article demonstrates how you can implement this functionality in your addin.
Mon, 19 Feb 2007 09:10:00 GMT
I've added some information on troubleshooting startup trouble caused by COM addins.
Fri, 09 Feb 2007 17:40:00 GMT
Toegevoegd is een aantal tips om problemen veroorzaakt door COM invoegtoepassingen te onderzoeken.
Autosafe is now freeware. Autosafe backs up your work in Excel. When you restart Excel after a crash, you're offered to restore backed up copies of your files. You can also restore previous backup copies from your recycle bin to revert back to an older version of your work. This new version of Autosafe will work with long path+filenames (previous versions didn't).
Thu, 01 Feb 2007 09:31:00 GMT
With the release of Office 2007, everything has changed regarding user interface programming in Excel. I've updated my set of articles on distributing macros today, with special sections on Excel 2007 where appropriate.
Fri, 26 Jan 2007 11:50:00 GMT
Build 580 of Name Manager fixes a rarely occuring problem which prevented it from loading, showing an "Invalid Picture" error.
Thu, 18 Jan 2007 08:10:00 GMT
With the release of Excel 2007, Microsoft has introduced a new concept of working with tables of data. This new functionality is (not surprisingly) called "Data Tables". This article introduces you into the concepts of working with Data Tables and shows you how they may help you in your everyday Excel use.
Fri, 12 Jan 2007 13:30:00 GMT
I've added an Excel 2007 version of Flexfind. Only change: inserts a control on the ribbon for easy access.
Tue, 19 Dec 2006 08:40:00 GMT
Als je net zoals ik een VBA programmeur bent, dan vindt je het wellicht ook belangrijk hoe de verschillende vensters van de Visual Basic Editor zijn geplaatst. Soms maakt de VBE er een rommeltje van en het kan op zijn zachtst gezegd een uitdaging zijn om ze weer allemaal op hun plekje te krijgen. In dit artikeltje laat ik je zien hoe je dat kunt doen.
Fri, 15 Dec 2006 15:45:00 GMT
If you're a VBA programmer like me, you're probably picky about your window arrangements in the Visual Basic Editor. Sometimes it messes things up and it can be a challenge to get those windows where you want them. Here are some tips to get things back in order.
Wed, 06 Dec 2006 18:00:00 GMT
Build 577 of Name Manager fixes a small bug related to renaming local names.
Wed, 29 Nov 2006 15:45:00 GMT
I have uploaded an Excel 2007 RTM version of Build 576 of Name Manager today.
Fri, 24 Nov 2006 10:15:00 GMT
Build 576 of Name Manager fixes a small bug related to use of Name Manager in an Office MUI language situation. Added functionality: delete names by pressing the del key.
Wed, 15 Nov 2006 14:00:00 GMT
Build 575 of Name Manager fixes a small bug related to renaming a name which is not in use.
Sat, 04 Nov 2006 15:04:00 GMT
This new version of Autosafe will work with long path+filenames (previous versions didn't).
Fri, 27 Oct 2006 12:15:00 GMT
Deze versie maakt gebruik van Autosafe mogelijk in situaties met lange bestands en padnamen.
For those of you who are using and testing Excel 2007 (Beta 2), Name Manager for Excel 2007 is available on this page.
Mon, 18 Sep 2006 10:40:00 GMT
Recently someone asked me if it was possible to transpose a table of cells, but in such a way that the formula of each cell is kept intact. I decided VBA was the way to go and produced a small but very useful little routine for that.
Fri, 15 Sep 2006 18:00:00 GMT
Recentelijk vroeg mij iemand of het mogelijk is om een tabel met cellen te transponeren, zodanig dat de formule van elke cel intact blijft. Ik besloot dat VBA de aangewezen weg was om dit te bereiken en heb een kleine maar handige subroutine gemaakt die dat doet.
New features: 1. Rename a name. Name Manager now includes a rename option, which will enable you to change the name of a name and have all objects that use that name update too. 2. View where name is in use. A treeview shows all locations where a name is used, including VBA code.
Mon, 12 Jun 2006 18:40:00 GMT
Nieuwe mogelijkheden: 1. Hernoem een naam. Name Manager geeft u nu de mogelijkheid om een naam te hernoemen. Hierbij worden alle formules die gebruik maken van die naam ook bijgewerkt, evenals mogelijke objecten (grafieken, besturingselementen e.d.); 2. Toon waar een naam precies in gebruik isinclusief in uw VBA code.
De Application.InputBox functie is zeer handig om een bereik door de gebruiker te laten selecteren, waarmee vervolgens in de VBA code verder gewerkt kan worden. Helaas bevat deze functie een bug (all huidige Excel versies hebben deze bug). Wanneer er op het werkblad waarop een bereik wordt geselecteerd voorwaardelijke opmaak is ingesteld waarbij bovendien gebruik is gemaakt van de optie "formule is", dan kan de functie een lege string als resultaat teruggeven.
Tue, 30 May 2006 17:30:00 GMT
NavigatorXL ends the spreadsheet chaos and smoothens the path for really value-added business intelligence solutions. With NavigatorXL you can: Distribute updated spreadsheets throughout your business organization. Secure your spreadsheets so department managers are only allowed to see their department's data. Combine multiple data sources into one spreadsheet. Combine local spreadsheet with updated budgets with actual data from your corporate system. Collect updated forecast figures entered in a sales pipeline spreadsheet. Create an Excel form (expense report, timesheet...) and collect and share the data centrally.
Sun, 21 May 2006 14:50:00 GMT
If you have created a nice add-in, a setup utility is an easy way for your users to install your addin. This free utility just needs you to change 4 cells to roll your own setup file. Update: Now automatically removes invalid addins from addin list (courtesy: Richard Reye).
Thu, 11 May 2006 08:45:00 GMT
The Application.InputBox function is very useful to get a range from the user. Unfortunately, this function exposes a bug in Excel (all current versions!). If the sheet on which a (range of) cell(s) is selected contains conditional formatting using the : "Formula Is" option, the function may fail, returning an empty range.The only reliable workaround is to build a userform to request the range from the user, which I have included as a download.
Thu, 04 May 2006 10:30:00 GMT
I have fixed a couple of bugs in Beta 4 of the Name Manager (build 554).
Thu, 04 May 2006 10:20:00 GMT
I have fixed a couple of bugs in Beta 4 of the Name Manager (build 550) and added a feature: show a list of all places where a name is in use.
Fri, 28 Apr 2006 10:45:00 GMT
New feature: Rename a name. Name Manager now includes a rename option, which will enable you to change the name of a name and have all objects that use that name update too. This new feature has yet to be tested thoroughly though, so that is why this version is still in Beta stage. Test drive version 4 and report any problems to me.
Tue, 11 Apr 2006 09:00:00 GMT
Microsoft Office 2003 Professional is de eerste Office versie die de XML standaard echt serieus neemt. De XML standaard is ingesteld om het markeren van gegevens (met name op het web) te vergemakkelijken. De standaard vindt steeds meer toepassing. Een bekend voorbeeld zijn RSS feeds waarmee men nieuws kan vergaren van internet pagina's. Deze zogeheten RSS-feeds zijn niets anders dan XML bestandjes. Dit artikel geeft een inleiding in wat XML is en wat er (met name in Microsoft Excel) mee gedaan kan worden.
Wed, 05 Apr 2006 07:00:00 GMT
In Microsoft Word kan men wijzigingen die door VBA code in een document worden aangebracht standaard ongedaan maken. In Excel is dit helaas niet het geval. Vrijwel alle macro commando's legen de Undo "stack" en de acties zelf kunnen niet meer ongedaan worden gemaakt. Om dit toch mogelijk te maken, moet men code schrijven die: De vorige staat van alles dat gewijzigd gaat worden opslaat; Een routine instelt die uitgevoerd moet worden wanneer de gebruiker voor "ongedaan maken" kiest; Die routine programmeren, die de wijzigingen die door de code zijn uitgevoerd weer ongedaan maakt, in omgekeerde volgorde. In dit artikel wordt gedemonstreerd hoe twee klasse modules kunnen worden ingezet om een (min of meer) generieke "undo handler" te bouwen, welke in elk Excel VBA project kan worden ingezet.
Tue, 04 Apr 2006 08:20:00 GMT
A heads-up to all VBA developers. I've just updated AutosafeVBE, the utility that backups your VBA projects. Now handles up to 9999 generations!
Thu, 23 Mar 2006 18:40:00 GMT
Unlike Word, changes made to an Excel workbook by using VBA cannot be undone easily. One has to write code that: 1. Stores the previous state of anything that (possibly) needs to be undone. 2. Sets a sub to be run when the user selects undo. 3. Write that subroutine, which reverses the changes last made by your code. In this article I will demonstrate how one can use two class modules to create a (more or less) generic undo handler which one can plug into any project.
Thu, 09 Mar 2006 06:50:00 GMT
I have recently added a database to my site. Now I am learning classic ASP and VBScript (I know, why not .NET?) to use this database and put some interactivity on my site. Take a look! Some articles now have a set of stars at their final page with which you can rate them.
Fri, 24 Feb 2006 19:10:00 GMT
When one writes a User Defined Function in Excel VBA, this function appears in the function wizard under the category "Custom". It is possible to change the function category by changing the "macro properties" of the UDF. Unfortunately, VBA does not allow specifying descriptions for the UDFs arguments. One can do this using the old XLM REGISTER function in conjunction with the ExecuteExcel4Macro function from within VBA. This function only accepts 255 characters or less, insufficient for UDFs with more than just one or two arguments. This article describes how this can be overcome, using an ancient XLM macro sheet together with some trickery invented by Laurent Longre.
Fri, 17 Feb 2006 08:20:00 GMT
When working with Excel worksheets with a lot of used columns, it would be easy if one could have a way to show the content of a column on the same row in a window. This new WatchOtherCell utility does just that.
Thu, 09 Feb 2006 14:20:00 GMT
Tue, 03 Jan 2006 20:00:00 GMT
Sometimes Excel VBA behaves unexpectedly. Here is an example: You are running code that is meant to open one or more files using the Workbooks.Open command. As soon as you hold down the shift key when this command is being processed, macro execution stops and your program is terminated entirely. This will even happen if you are e.g. editing an email message in Outlook whilst Excel VBA is processing the code in the background.
Fri, 11 Nov 2005 12:30:00 GMT
Het gebeurt regelmatig, dat ik een bereik met formules heb dat op zich goed werkt, maar dat een foutcontrole nodig heeft, bijvoorbeeld om delen door nul te voorkomen. Dit artikeltje toont wat VBA code om de formules in een reeks cellen te converteren zodat ze een foutcontrole krijgen.
Mon, 31 Oct 2005 12:30:00 GMT
Dit artikel is nu volledig in het Nederlands beschikbaar!!! Beschrijving: Excel is een van de meest gebruikte toepassingen in het bedrijfsleven. Het pakket staat bol van de standaard functies. Daarnaast biedt het zoals bekend de mogelijkheid taken te automatiseren via macro's geschreven in VBA. Veel gebruikers starten met het opnemen van macro's, komen vervolgens tot de ontdekking dat de macro recorder geen code oplevert die algemeen toepasbaar is en starten zo zelf met het programmeren. Er komt soms een moment, waarop de gebruiker een macro heeft ontwikkeld die anderen ook graag zouden willen gebruiken. Dat is het moment dat een dergelijk macro zal moeten worden omgezet naar een voor anderen bruikbare utility. Dit artikel geeft een overzicht van de zaken die daarbij aan bod kunnen komen.
Tue, 25 Oct 2005 13:30:00 GMT
Events zijn een krachtig hulpmiddel bij het programmeren met Excel. Events maken het mogelijk te reageren op acties van de gebruiker zoals het bewerken van een cel of het klikken van de knop Afdrukken. Wanneer een applicatie gebruik maakt van events, dan is het ook vaak nodig de controle te hebben over het feit of de code in het event wel of niet wordt uitgevoerd (bijvoorbeeld om te voorkomen dat de event code in een oneindige lus geraakt of om programmacode de mogelijkheid te geven acties uit te voeren die het event voorkomt). Dit artikel toont hoe u events onder controle krijgt.
Fri, 07 Oct 2005 17:50:00 GMT
Events are a powerful aspect of Excel programming. They enable you to make your application respond to user actions such as entering data into cells or clicking the print button. If your application uses events, you will probably also need to be able to control whether or not an event executes its code or not (e.g. to avoid event looping or to enable your code to do things you are preventing your user to do through the user interface). This article shows a method to gain fine control over which event fires and which does not.
Wed, 14 Sep 2005 08:30:00 GMT
Excel is een van de meest gebruikte toepassingen in het bedrijfsleven. Het pakket staat bol van de standaard functies. Daarnaast biedt het zoals bekend de mogelijkheid taken te automatiseren via macro's geschreven in VBA. Veel gebruikers starten met het opnemen van macro's, komen vervolgens tot de ontdekking dat de macro recorder geen code oplevert die algemeen toepasbaar is en starten zo zelf met het programmeren. Er komt soms een moment, waarop de gebruiker een macro heeft ontwikkeld die anderen ook graag zouden willen gebruiken. Dat is het moment dat een dergelijk macro zal moeten worden omgezet naar een voor anderen bruikbare utility. Dit artikel geeft een overzicht van de zaken die daarbij aan bod kunnen komen.
Tue, 23 Aug 2005 18:50:00 GMT
Oftentimes I have a range filled with formulas that as such work correctly, but need an error checking mechanism. For example to account for cells that are empty. This article shows some code to achieve that. But there is more. I plan to add functionality as we get along.
Tue, 19 Jul 2005 20:40:00 GMT
In Excel you can give a range of cells a name. When you do that, you can use this name instead of the address to point to that range. In general it is easier to remember a name than a range address of the start and end of a range of cells. Using names has a couple of advantages: ranges are easier to find, formulas are simpler to understand and maintenance of the spreadsheet model becomes more reliable. Furthermore, some things in Excel can only be achieved by using defined names. But much more is possible with defined names than just naming a range of cells. Because you can also put a formula into a name, a whole world of possibilities opens up! Even more so, since you can also put the old Excel 4 macro functions to use in a defined name. This enables you to do things normally only possible using VBA.
Wed, 6 Jul 2005 20:00:00 GMT
In Excel is het mogelijk een bereik van cellen een naam te geven. Wordt dat gedaan, dan kan voortaan deze naam gebruikt worden om naar dat bereik te verwijzen, in plaats van het adres. Over het algemeen is een naam van een bereik makkelijker te onthouden dan het adres van de begin- en eindcel van een bereik. Het gebruik van namen heeft een aantal voordelen: bereiken zijn eenvoudiger terug te vinden, formules zijn makkelijker te begrijpen, enzovoorts. Verder zijn er zaken in Excel die alleen mogelijk zijn door een bereik eerst een naam te geven. Maar er kan veel meer met namen in Excel. Er kunnen ook formules in gebruikt worden en dat opent een wereld van mogelijkheden. Sterker nog, omdat tevens de oude Excel 4 macro functies in een gedefinieerde naam mogen worden toegepast zijn dingen mogelijk die normaal gesproken alleen via een VBA macro kunnen worden gerealiseerd. Dit artikel is reeds eerder in het Office magazine (nummer 21, april 2004) verschenen.
Tue, 28 Jun 2005 09:40:00 GMT
Show less news
