Modules are just bags of code, intended to be shared between more than one worksheet or object. You can't explicitly place modules into the Objects folder; code that lives there is actually contained ...

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques. The article Five ways to take advantage of Excel list features showed five ...

Create a quick and effective dashboard using Excel’s PivotChart and Slicer objects Your email has been sent Learn how you can combine PivotChart and Slicer objects to create an easy-to-use and dynamic ...

I have an excel file a coworker sent me that lags tremendously. I tried to narrow the problem, until I deleted all the data on the sheet, and the file would still lag. I checked the file for any ...

We're going to build off my previous series to show how to further the communication channel between Excel and PowerShell. In a recent series of posts, I explained how to launch a PowerShell script ...