Let us assume, I have a list of values (numbers or alphabets) in one column and each value has 6 digits. I want to mask the first 3 digits with * (asterix) and show the last 3 digits only ...
Let us assume, I have multiple tables in my Excel worksheet. I want to email the tables as it is (with color, fonts etc.) as HTML table in the email body. I’ll show you how easily you can do this ...
In this post I’ll show you how split text string from one cell to multiple cells. I’ve shared 2 different methods: using a new function called TEXTSPLIT and another using a macro in VBA. In-addition ...
You can convert your worksheet data into a table using a macro or without macro. Both the process is simple. However, sometimes we need a small program or a macro to automate a process. ...
The isNumeric() function in VBA is often used to check if a cell has numbers in an Excel worksheet. However, there is a super simple method to do this. You can use RegEx or Regular Expressions ...
Here in this post I’ll show how to use RegEx (or regular expressions) in VBA Excel to extract a given pattern from string. ...
Let us assume I have an Excel file in a folder and I want to copy data as it is to another file (a master file) using VBA. When I am saying as it is I mean the macro should copy data from sheet to ...
You can insert an image in Excel by simply dragging and dropping it anywhere in your worksheet. Its a floating image, that is, you can drag or move the image anywhere in your worksheet. However, with ...
There are few simple methods in VBA to check if a workbook or a file is open or not. One of the easiest methods is to loop through all the open workbooks and identify the file that you are checking. ...
Here in this post I’ll show you “two” different methods to show (or display) a progress bar in your Excel worksheet using VBA. ...