Unlock VBA Project Password in Excel
Sometimes, you may forget the password you have used to protect the VBA project in your Excel file or inherit a workbook from a user with an unknown VBA project …
Excel VBA / Macros
Useful Excel VBA Macro Codes Examples
VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft. It is primarily used to automate repetitive tasks in Microsoft Office applications like Excel, Word, …
VBA Macro Codes to Filter Data In Excel
Excel offers a lot of built-in filtering options. You can do a lot of basic and advanced filtering using the in-built options. But with VBA, you can take the filtering …
How to Select Multiple Items from a Drop Down in Excel?
A drop-down list in Excel is a data validation tool that allows users to select values from a predefined list of options. The default behavior of a drop-down list in …
How to Select Every Other Row (Alternate Row) in Excel?
Selecting every other row in Excel could be useful when you want to manipulate alternate rows in your data set. For example, you may want to highlight every other row, …
Remove Blank Rows in Excel (5 Ways + VBA)
A dataset in Excel containing blank rows is challenging to read and navigate and can lead to computational errors. Therefore, we must remove the empty rows to resolve such problems. …
How To Hide Formulas In Excel Without Protecting the Sheet?
Sometimes we may need to hide formulas in our Excel worksheet without necessarily protecting the sheet or protecting the cells that have the formulas. In this tutorial, I will cover …
Subscript Out of Range Error in VBA – How to Fix!
Sometimes when we write and attempt to run sub-procedures in Excel VBA, Excel VBA returns a message box with the error message “Runtime error 9: Subscript out of range.” The …
How to Delete Defined Name in Excel? (Name Manager + VBA)
We define and use names in Excel formulas to easily understand, reference, and maintain data. For example, we can define a name for a table, a cell range, a constant, …
Switch First and Last Name with Comma in Excel (Reverse Names)
If you’ve ever been tasked with organizing a list of names in Excel, you know how frustrating it can be to get the formatting just right. A common format when …
How to Separate Date and Time in Excel?
There may be times when you import datasets and find that date and time columns have been combined. In this tutorial, we are going to look at seven simple methods …
How to Filter Multiple Columns in Excel?
In Microsoft Excel, when we apply a filter to a specific column it only filters all the columns based on that specific column. But we often came across situations where …