XLWizardry
Hello and welcome to XLWizardry. My name is Michael and I've been a software developer for over 30yrs where I worked with many different languages such as VB.Net, C#, ASP.Net, JavaScript, C and SmallTalk.
But from 2017, I've mainly been developing Excel/VBA tools to automate many of the processes performed by business users, reducing the effort and risks involved with the manual procedures they replaced.
So I thought I'd share some Excel tips and tricks that I developed over the years and to mix it up I'll also throw in some home DIY and areas of personal interest.
Hopefully you find something useful or interesting to you.
Thank you for watching.
Honda CRV Android - Fixed Steering Wheel Controls, Camera & iMID
Error Handling In Excel VBA - Part 1
Disable These Settings In Your Macro
Why You Should Use Option Explicit In Excel VBA
Ways To Find Last Row & Column In Excel VBA
Debugging In Excel VBA - A Must Have Skill
How To Reference Ranges In Excel VBA - Part 2
How To Reference Ranges In Excel VBA - Part 1
Easy Way To Clean Your Shower Grate
How To Reference Worksheets In Excel VBA
I Fixed My Satnav Not Locking Onto Satellites
How To Access Bosch Home Professional Dryer Service Menu
Don't Waste It! Use More Of Your Line Trimmer Cord
Dynamic Conditional Formatting In Excel
Fix Automatic Repair Loop When Secure Boot Is Enabled | Battlefield 6 / Windows 11
How To Access Bosch Serie 8 Washing Machine Service Menu
Help Identify AC Milan Autographs (1993)
Strange Thing Caused Mower To Keep Stopping
Inter Milan 97/98 Jersey - Ronaldo 10
Magnetic Door Stop Mod
Exclude Data Above & Below an Excel TRIMRANGE
Wall Vent Flyscreen Mod
TRIMRANGE & Dot Operator Differences Rarely Mentioned
Freezer Condensation Fix
Dynamic Named Ranges In Excel
NTKK Snakebelly BMX Tire Remake
SUM Matching Row and Column Criteria In Excel
My 1980 Diamond Back BMX
Dynamic Combinations In Excel from 3 Lists
Dynamic Combinations In Excel from 2 Lists