How to Insert a Check Mark Symbol [Tickmark] in Excel
Last week while traveling… …I met a person who asked me a smart question. He was quietly working on his laptop… …and suddenly asked me this:“Hey, do you know how to insert a
VBA
How to Create Excel PERSONAL.XLSB MACRO Workbook for VBA Codes
If you use a lot of VBA codes like me……then you need to have a place where you can store all of them and use them whenever you need.But the
How to Create a User Defined Function [UDF] in Excel using VBA
In Excel, there are more than 450 functions and some of them highly useful in your daily work.But…Excel gives you the ability to create a custom function using VBA.Yes, got
How to Highlight Duplicate Values in Excel using VBA Codes
While working with huge data, duplicate values are always a concern. Most of the time I use remove duplicate option to remove all those values. And, I’m sure you do the same.But
How to Extract Hyperlink Address (URL) in Excel Using VBA UDF
Let’s say you got an Excel workbook from your colleague where you have a list of hyperlinks in a column. Now from this list, you want to extract all the hyperlink
How to Activate a Sheet using VBA
Let’s say… …you are working with multiple worksheets, and for you, it’s hard to navigate to a sheet using tab. In this situation, you can use a VBA code to activate any