Hi all,
So after Dicks (nice to read) rambling on golf, let’s do some Excel/VBA stuff again.
I intend to get a bit of discussion on this one, so bear with me.
I’m currently developing an Excel workbook for a customer. One of the interesting things with this project is that it consists of...
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...
I’m in Seattle for the MVP Summit. This hotel is great. I just downed a whole jar of complimentary Macademia nuts and… What’s this thing that looks like a menu? Damn!
I’m off to register and score some of the Rock Bottom brew. I’ll be sure to have one for those [...] Read...
Mike from the Northeast won the 4-year anniversary contest. A copy of Dalgleish’s Excel Pivot Table Recipes is soon to be rushing to his house from wherever Amazon rushes stuff. In the contest, I asked for your favorite non-Excel blogs, and here are some of them:
Office Live Small Business…...
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...