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...