List Hyperlinks From All The Worksheets with VBA

If you work with an Excel workbook that contains many hyperlinks across many worksheets, and you want to create a report to list out the information of each hyperlink, doing that manually sounds crazy to me (I have seen that in real live that actually...

Merge Multiple CSV Files in Excel with VBA

Merge bunch CSV files into one single Excel file manually requires a lot of time and efforts, and on top of that, it’s a painful task. What if you can automate the process with just a single macro?In this tutorial, I will teach you how to write a VBA script to...

Delete Rows with Strikethrough Texts in with 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

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...