VBA Hurts - A Lot

1-minute read

Today I had to make some changes to an in house macro and it just reminded me of the fact that VBA causes brain damage. I really dislike this language and try to avoid it as much as I can. An example of it’s stupidity is the fact that it uses the same operator for both assignment and comparison. Then the VBA standard library is just too poor, there doesn’t seem to be a method to remove all objects from a given collection which results in self made solution like the following.

Do While mycollection.Count > 0
    mycollection.Remove(1)
Loop

Enough ranting for today, hope you don’t have to use this crap.

Marc