Apr 14, 2020 | Excel, VBA
In this Excel VBA tutorial, we will be creating a User-Defined Function (aka UDF) to validate if IP addresses are valid. Assuming you have a spreadsheets with a list of IP addresses, and your job is to validate whether each IP address is valid. My personal experience...
Mar 10, 2020 | Excel, VBA
In this tutorial, we are going to write an automation script to split a table in Excel using VBA. Using VBA, you can break down a source worksheet to multiple Excel file based on the values in the selected key columns, and doing so, will keep your data secure without...
Oct 28, 2019 | Excel, VBA
In this tutorial I am going to show you how to create a Folder Generator App in Excel. We will be writing some VBA to perform the folder creation. Buy Me a Coffee? Your support is much appreciated! PayPal Me: https://www.paypal.me/jiejenn/5 Venmo: @Jie-Jenn Download...
