VBA Script for Excel to Automatically Color Pie Chart Slices Based on Cell Fill Colors. This repository contains a VBA (Visual Basic for Applications) script designed for Microsoft Excel. The script, ...

This repository includes the ".bas" files for Markov Chains that accompany the book entitled: Markov Chains: From Theory to Implementation and Experimentation. These ".bas" implementations can be used ...

Let’s be honest— Microsoft Excel is a powerhouse, but it can also feel like a time sink. Whether you’re formatting endless tables, sorting mountains of data, or generating the same reports over and ...

Excel is a powerful tool for organizing and analyzing data. But did you know that you can also use it to send emails? By writing a VBA script, you can automate the process of sending emails from your ...

Have you ever found yourself staring at a sprawling Excel workbook, wondering if you’re using the right tool for the job? Between Power Query, Power Pivot, and VBA, it’s easy to feel like you’re ...

Back in December, I wrote about Microsoft’s decision to drop support for Visual Basic for Applications (VBA) from the next version of Office. I had, and still have, many concerns about the switch. The ...