Category Archives for VBA

VBA Codes to Highlight Duplicate Values in Excel

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, removing these duplicate values or just counting them never sort out the problem. The important thing is to review all the duplicate values before […]

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 URL addresses.The manual method is a real pain, you need to copy-paste each URL one by one.So the better way is to create a UDF […]

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 worksheet. And, to write a VBA code for this you need to use Worksheet.Activate Method. In this post, I’d like to share with you a simple […]

VBA Code to Search on Google

 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 useful macro codes, I have a code which you can use to perform a search query on Google using Chrome. And today, I’m gonna share that […]

How to Concatenate a Range of Cells in Excel [5 Methods]

CONCATENATE is a handy function to concatenate text from different cells. You need to refer to the cells which you want to combine. It’s simple and easy to apply. But here is a bad news. In concatenate, it’s not possible to refer to an entire range. You need to select all the cells of a range one by one. […]