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
VBA
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
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
How to Search on Google using a VBA Code
There are a lot of important things which we all do other than using Excel. Am I right? One of those things is using Google to search for something.In my list of
Top 100 Useful Excel Macro [VBA] Codes Examples
Macro codes can save you a ton of time.You can automate small as well as heavy tasks with VBA codes.And do you know? With the help of macros……you can break all