Use Python to replace VBA in Excel
Did you know that you can completely replace VBA in Excel with Python?
Script and automate Excel using nothing but Python, and write macro functions (Subs) and worksheet functions (UDFs) using PyXLL.
PyXLL
https://www.pyxll.com
Resources for VBA developers
https://www.pyxll.com/learn-python