Hi All,
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). UDF’s typically are placed in addins. As long as the addin is installed, the UDF’s...
Hi all,
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. The array contained something like: Description
Before
After Cell Errors
100
10 Corrupt Names...
Hi All,
As many of you know I give away a number of tools for Excel through my site www.jkp-ads.com. Today I have updated the two most popular downloads:
Name Manager (which I created together with Charles Williams, www.decisionmodels.com):
Most important change: the unused names filter now includes...
Hi all,
Let me start this post with a shameless plug: Charles Williams and I developed Name Manager. From my website alone this tool is good for about 60 downloads a day.
Just a couple of weeks ago, all of a sudden Charles and I started receiving complaints about compile errors, which neither of us could...