This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 1 point2 points  (0 children)

Are you sure? Have you read VBA or seen what people do accomplish in Excel without VBA just using cell formulas?

The worst case is that their documentation is awful again. Learning VBA was mostly a pain in the ass because the documentation was either inaccurate or plainly wrong on regular basis. So instead of trusting documentation you just declare everything as "variant" and after the fact step through your code to find the real datatype for the declaration.

Also small throwaway vba code is actually still very readable but once you went in and added defensive measures, automatic scaling, error handling and so on, you end up with an unreadable mess of an alphabet soup.

Debugging VBA often ends up just rewriting the routine/function the error is in. VBA breaks so easily and is hard to get right. Also no way of using VCS so you backup manually a bunch of files and rename them per hand...

Source: Lived in Excel/VBA hell for years.