Delete Rows with Strikethrough Texts in with Excel VBA

Apr 29, 2019 | Excel, VBA

Quiet often when you collaborate with a team member or group of people on a Excel spreadsheet, when the most commonly thing is people will apply strikethrough to the items or texts they want to remove from the file. Not sure why in Excel, there is no function to...

Turn Off the Privacy Warning Notification

Apr 19, 2019 | Excel, VBA

When you work with Excel files that contain macros, ActiveX Control, userforms, or connect to an external data source, sometimes, you will get those annoying Privacy Warning message “Be careful! Parts of your document may include personal information that...

Implement Audit Trail Feature to Track Changes

Apr 15, 2019 | Excel, VBA

An audit trail is a record or log captures a change. For example, when you change a product price from $10 to $15, the change in the $5 difference is a trail. Audit trail is commonly used in accounting, finance, retail, and other industries. Unfortunately in Excel,...

Find the Last Row and Last Column in Excel using VBA

Apr 9, 2019 | Excel, VBA

When writing VBA, one of the most important things is to figure out the table dimension, like figuring out the last row and last column of a table. Using VBA, we can easily write just few lines of code to find the last row and last column index....

Create a Vlooup Function To Extract All The Associated Values

Apr 5, 2019 | Excel, VBA

One of the limitations with Excel VLOOKUP function is that, when you have multiple matched values, the function will return the first matched record. In this tutorial, I will show you how to create a Used Defined Function (UDF) to perform VLOOKUP that can extract...