Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

Category Archives for VBA

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 […]

➲ Continue Reading

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 […]

➲ Continue Reading

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 […]

➲ Continue Reading

5-Popular Ways to Concatenate a Range of Cells in Excel

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 […]

➲ Continue Reading

Count Unique Values in Excel

Let’s say you have a list of values where each value is entered more than once. And now, you want to count unique values from that list so that you can get the actual numbers of values which are there in the list. For this, you need to use a method which will count a […]

➲ Continue Reading