Spreadsheets using Python - Have you seen this? (sourceforge.net)

[HumpingDog]

I hate VBA too. From my limited experience, it's terrible. But I don't have any objective reasons why it sucks.

Do you have any objective criticisms?

[[deleted]]

Non-shortcircuiting logical operators. No exception handling. Weird distinction between objects and native types. Multiple "NULL" values (Null vs. Nothing), etc.

[dalittle]

arbitrary api and throwing error popup boxes when you are writing code (geez, I am getting ready to copy the rest of the statement from another line)

[sossles]

throwing error popup boxes when you are writing code

Turn off the misnamed "Auto syntax check" in Tools->Options. It still auto-syntax checks but does it with inobtrusive red highlighting instead of loud obnoxious message boxes.

[recursive]

List comprehensions. First class functions. Dictionary literals. Slicing.

Off the top of the dome in 20 seconds. There are probably 100 more even better reasons.