Trying to do anything complex with VBA arrays is like banging your head on a wall but without that satisfying feeling when you stop. Because of this, I created this class to do the nifty stuff I can ...

Array languages are awesome. People should be aware of what they're missing out on. This repo offers proof-of-concept implementations of some array programming primitives that are missing from ...

So, I am writing an application in Excel2000 and VBA. I am using Autofilter to go through a bunch of raw data in a worksheet, filter it out, and copy it to a new sheet. For example, I have a sheet ...

Among all the exciting announcements made at Ignite last week, one you may have missed (even in all the Excel-related announcements here) was that dynamic arrays have finally reached GA. Ever since ...

Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get Excel to average values, conditionally.

OK, I'm having a problem making a function call from VBA to C++. I'm not even sure if it is possible to do this.I have a c++ function whose header looks like this: int32 myDllFunction ( int32 ...