For complex formulas and vba, what's your recommendation: Claude vs. ChatGPT vs. Gemini (assuming all paid services)

To be honest, I have a montly subscription for ChatGPT and Gemini. The last couple of months, I believe Gemini has been superior specifically for excel complex formula generation or vba. However, I keep reading that Claude (Opus) is by far the best for coding, so I would guess it would be the better choice among these AI services?

What's your take??