Blog
Page 342 of my articles, tutorials, and thoughts
Latest Articles
Should I use Call keyword in VB/VBA?
# š Should I Use Call Keyword in VB/VBA? š¤ Are you a VB/VBA developer who's been wondering if you should use the `Call` keyword when calling subs? š¤ Well, you're not alone! It's a common question, and in this blog post, we'll explore the pros and cons
Returning a regex match in VBA (excel)
š **Returning a regex match in VBA (Excel): A Comprehensive Guide** Are you struggling to return a regex match in VBA? š¤ Whether you're looking for a specific value in an unstructured text or dealing with the pesky #VALUE! error, we've got you covered!
How do I get the old value of a changed cell in Excel VBA?
## š Tech Blog: How to Get the Old Value of a Changed Cell in Excel VBA Have you ever found yourself in a situation where you need to know the old value of a cell that was just changed in Excel VBA? It can be frustrating when you're trying to track chang
Skip to next iteration in loop vba
# š Skipping to the Next Iteration in VBA: A Simple Guide Looping through data is a common task in VBA, but what if you need to skip to the next iteration based on a condition? In this blog post, we'll tackle this issue head-on and provide you with easy
Excel"s fullname property with OneDrive
# Excel's Fullname Property with OneDrive: Solving the "https" Dilemma šš»š So, you've saved an Excel file to your beloved OneDrive, but when you try to retrieve its full name using the open Workbook object, you encounter a little hiccup. Instead of rec
VBA collection: list of keys
# Retaining the Keys in a VBA Collection šļø If you have ever worked with VBA collections, you might have come across the question of how to retain the list of keys. In this blog post, we will explore the solution to this common issue and provide you with
Is VBA an OOP language, and does it support polymorphism?
š„ļøšØāš» **Is VBA an OOP language, and does it support polymorphism?** š§©š¤ So you're delving into the world of VBA (Visual Basic for Applications) for the first time and trying to figure out if it's an Object Oriented Programming (OOP) language. You've c
Easiest way to loop through a filtered list with VBA?
šš Looping Through Filtered Data: The Simplest Solution with VBA šš” Hey there, tech enthusiasts! š Looking for the easiest way to loop through a filtered list using VBA? Look no further because we've got you covered! šŖš» š„ Problem: So here's the
Populating VBA dynamic arrays
# š Tech Blog: Populating VBA Dynamic Arrays Made Easy! š Are you experiencing an error š« that says "subscript out of range" when trying to populate a dynamic array in VBA? Fear not! This blog post will guide you through common issues and provide easy
How to "flatten" or "collapse" a 2D Excel table into 1D?
# How to "Flatten" or "Collapse" a 2D Excel Table into 1D š Do you have a large 2D Excel table and want to transform it into a 1D format? If you're looking to collapse or flatten your table, we've got you covered! In this guide, we'll walk you through th