Hi Paul -- great to meet you. I'm currently working on an Excel Fundamentals course, and SQL and VBA are scheduled after that. But to get you started, I’ll mind dump a bunch here. I've also attached a file with a few code examples that I talk about below. You can learn quite a bit in a month. ########################################################### 1️⃣Tool #1 — Record Macro The most powerful tool for self-directed learning is using the Record Macro feature. Excel will watch what you do and write the VBA code that will execute exactly what you did. (select a Cell, Type a Formula, Recalculate (F9), Move A Chart, Scroll the window, etc…) To view the code you’ve recorded, Access the VBA section with the shortcut ALT+F11 Once you see the VBA Project Explorer (looks like a windows explorer with folders under each Excel File you have open), open the folder that says “Modules” and open the most recent module (if you have multiple modules, it will have the largest number) You’ll see the code you recorded. This is especially helpful when you’re automating something you do with keyboard and mouse in one of your own files. Once you have the code, you can either use it just as it is, or customize it. To customize it, you’ll need a couple things: — A dictionary to look up what all the terms mean — A crash course in how the language is set up with examples of some of the most useful ideas and examples And that’s what I’ll cover next. ########################################################### 2️⃣Tool #2 — Microsoft Learn (Excel VBA) This is your VBA Dictionary. Make it your friend. All the official information & definitions are here. You are a chef. This is where you learn about all the ingredients that are available and all the tools the kitchen has put at your disposal. I will warn you that some of the terminology they use takes a little getting used to, but I’ll give you a crash course on that next.

awesome! In the meantime, would love to hear your feedback and some of the wins of what you're able to do and build!

Hi Harlan -- my apologies for responding so late. Just so I understand, for some reason the CTRL-H dialogue box isn't working for you? A couple ideas come to mind. One is there's a way to do search & replace in VBA. Second, it may not work if executing the replace creates an error in a formula. Could you share an example file? I assume you've got it figured out by now but I'm curious to see what you were experiencing.