Wijzigingen aan deze site

De 20 meest recente wijzigingen

(In omgekeerd chronologische volgorde, zowel Engelse en Nederlandse pagina's):

Update: Name Manager
Name Manager has just been updated to build 706. Editing a name now also updates PowerQuery queries
Wed, 21 Feb 2024 15:30:00 GMT
Solving problems with VBA
I have just added a chapter to my article on solving startup problems in Excel, to solve an issue where Excel thinks it has lost the VBA code in a file
Wed, 14 Feb 2024 10:00:00 GMT
Updated: Flexfind
Flexfind was updated to add search and replace in Validation error message and input message text
Wed, 07 Feb 2024 15:00:00 GMT
Updated: Name Manager JavaScript edition
Today my Name Manager (JS edition) has been updated. Get your update by clicking in its task pane and pressing control+F5. Changes include: Bug fixes and slight Ux improvements
Tue, 06 Feb 2024 13:30:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser has just been updated to version 3.1, build 206. New menu item: Select cells with hard-coded numbers
Tue, 30 Jan 2024 15:15:00 GMT
Updated: Name Manager JavaScript edition
Today my Name Manager (JS edition) has been updated. Get your update by clicking in its task pane and pressing control+F5. Changes include: Now you can delete multiple names in one go
Tue, 30 Jan 2024 14:30:00 GMT
Update: Name Manager
Name Manager has just been updated to build 705. Updated the Reset button code to solve an issue with the dialog screen not appearing
Tue, 16 Jan 2024 09:30:00 GMT
Updated: Flexfind
Flexfind was updated to fix a form resizing issue
Mon, 15 Jan 2024 13:55:00 GMT
Office Script, more examples
I have added an example to my Office script examples page: how to find the last used row in a range.
Tue, 09 Jan 2024 10:10:00 GMT
Updated: Name Manager JavaScript edition
Today my Name Manager (JS edition) has been updated. Get your update by clicking in its task pane and pressing control+F5
Mon, 08 Jan 2024 14:05:00 GMT
New: Name Manager JavaScript edition
Good news! Today my Name Manager (JS edition) has been officially accepted to the Microsoft store!
Tue, 02 Jan 2024 11:55:00 GMT
Update: Excel File Remediation Utility
The Excel File Remediation Utility has been updated to build 137. Fixed a couple of bugs and added exceptions to deleting names with external references.
Tue, 05 Dec 2023 09:55:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser has just been updated to version 3.1, build 203. Added search in conditional formatting: databars, color scales and icon sets, Added Python support, Fixed bug in highlighting reference in formula, Fixed bug in Visualize, Fixed bug in insert link to ToC, Fixed bug in Formula report, now ignores text values starting with =
Thu, 09 Nov 2023 16:45:00 GMT
Updated: Table Tools
I have updated the TableTools add-in. Fixed a small bug in updating the queries
Tue, 24 Oct 2023 17:10:00 GMT
Updated: Flexfind JavaScript edition
Good news! Today I've updated my Flexfind (JS edition). To get the update, load the add-in in the usual way, click in it's pane and press control+F5
Mon, 16 Oct 2023 16:45:00 GMT
Updated: ExportVBAProject
I've fixed a small bug, if any of the VBA projects is protected the tool now gracefully exits. 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 Sep 2023 09:15:00 GMT
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
Updated: Flexfind
Flexfind was updated with an improved report (the List button)
Wed, 30 Aug 2023 13:55:00 GMT
Office Script, more examples
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
Updated: Flexfind now searches all types of conditional formatting
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