VBA Limitations

I mentioned earlier how I was doing some vba programming that was taking a fair bit of my time. Glad to say that it is now complete and working correctly.

So, what took so long. Having moved on from VBA to other programming languages, some of the methods I take for granted just aren't available which makes things take longer.

For example, you can't loop using the same element twice. That means having to run separate loops.

Next and this is the biggest one. The ability to check if an array contains a value isn't available either. Took a while and a lot more complexity to loop over the results.

Oh well, at least it is done and the client is happy.