Dynamic Gantt Charts In this video, I demonstrate how to create a dynamic Gantt Chart in Excel using VBA, including annotated “Event” diamonds to highlight key moments, like delays due to vandalism or bad weather. You’ll learn how to: Use VBA to create and add shapes (rectangles and diamonds) for chart visualization. Add event-specific code […]
Excel Auto Backup Tool (Free)
In today’s fast-paced, data-driven world, businesses of all sizes rely on spreadsheets for everything from daily tasks to business-critical operations. However, despite their importance, many overlook the risk of losing these invaluable files due to corruption or human error. That’s where the Free Excel Backup Tool comes in. This tool is designed to protect your […]

Excel Calendar Add-in Tool (Free)
https://youtu.be/lxR1HnjfQqQ Unlock the Power of Customization with My Excel Calendar Add-In! Welcome to my website, I’m showcasing my custom-built Excel Calendar add-in that’s designed to give you full control over your calendar’s appearance and functionality. Whether you need to mark specific days off, adjust the start of your week, or display up to four months […]

Hiring The Right Excel, Access, Word VBA Automation Expert
Hiring the right Excel, Access, Word and VBA Automation expert can be transformative for your business, streamlining workflows and unlocking the full potential of Microsoft Office tools. With decades of experience and a proven track record of delivering tailored solutions, unique challenges and business needs I will develop customized tools and automation systems that save time, reduce errors, […]
The Danger of On Error Resume Next
As a developer, you are in a position to make errors that can have awful consequences. I call them scary errors, the kind people lose their jobs over, the kind that cost real dollars. What follows is an made up example of an error I came across when I was called in to “fix a […]