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.

10000+ Copies Already Downloaded

Category Archives for VBA

Concatenate a Range of Cells

2 concatenate a range of cells with fill justify

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

Check it out now

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

Check it out now

How To Highlight Duplicate Values Using VBA

highlight duplicate values using vba

While working with huge data, Duplicate Values are always a concern. And, I am sure most of the time you remove them with remove duplicate option. But, removing duplicate values or just counting duplicate values never sort out the problem. The important thing is to review all the duplicate values before deletion. So, today I will […]

Check it out now

Useful Macro Codes Examples

useful macro codes

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 the limitations of excel which you think excel has?So, today, I have listed some of the useful codes to help you become more productive […]

Check it out now

How To Use VBA IF Statement To Write Conditions [Ultimate Guide]

a practical guide to learn about VBA IF Statement in excel

IF statement is one the most important parts of VBA coding. And, I am damn sure that after reading this guide, you will be able to write any type of conditional code by using this IF statement in VBA. Let me tell you something. Yesterday, I received a mail from one of my reader which […]

Check it out now