@Mikademus said:
Sorry to be a bastard -this might not be the answer you want-- but having worked professionally with VBA (Visual Basic for Applications, as in Excel) I have to say that the best way to fix it is to use another platform and language.
I agree, VBA pretty much sucks.
@Mikademus said:
I hate and loathe VBA and you may blast me for being biased or whatever, but it is the worst environment of all time,
Not anywhere near it, VBA is so far away from the worst environment. Not because it particularly good, just that there are far worse environments out there.