Category Archives for VBA

How to Count Unique Values in Excel [Formulas + VBA]

How to Count Unique Values in Excel [Formulas + VBA]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.For this, you need to use a method […]

Top 100 Useful Excel Macro [VBA] Codes Examples

Top 100 Useful Excel Macro [VBA] Codes ExamplesMacro 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 […]

VBA IF Statement

 Conditions are everywhere, in our work, day to day life, in our conversation, everywhere. And when it comes to VBA coding, conditions are one of the most important things. If you want to be advanced VBA user then an IF statement is must learn. And, I believe that you are already familiar with word IF and […]

VBA To Create a Pivot Table [Macro Code]

How to use a VBA Code to Create a Pivot Table [Writing a Macro Step By Step]  Before I hand over this guide to you to start using VBA to create a pivot table, let me confess something. I have learned using VBA just four years back and the first time when I wrote a macro […]

Add Developer Tab [Windows + Mac]

 Developer tab in excel is one of the most important and highly useful options in excel. But, before you use it you need add it on ribbon. When you install Excel, you need to activate it for first time. So today in this post, you will learn 3 different methods to add developer tab in Excel for windows as well […]