Uncategorized

Welcome to the most exciting and educational article on M code introduction. If you are a data enthusiast, then one or two skills in data analytics are not enough and you should always look forward to learning more skills to make yourself better competent in the data field.  Many students ask me what is the … Read more

Hey there, I am back again for you, my lovely VBA enthusiast! This morning I have already consumed 2 mug of coffee because of this article that I am writing. Hahaha. Actually, Arrays are my most favorite topic in VBA. It is used in my almost all client projects and help me a lot in … Read more

Welcome to this another thrilled and super exciting blog where I am going to teach you Error handlers. I bet, you will super love this article 👍👍. As we know Excel has a large number of formulas but if anything goes wrong, it throws an error, so to prevent errors, excel itself has Error handler … Read more

The IF function is one of the functions which is widely used in excel and makes it easy to classify the data as per the condition given. Lets go further in detail to understand the IF function and I will assure you that this blog post will help you to grasp your excel skills. 😀 … Read more

You are Learning below Topics:   What are IF statements and how to write a IF statement in VBA? Write IF AND Statements (Multiple Conditions) Write IF OR Statements (Multiple Conditions) Art of writing Nested IF Statements If you want to be an advanced Excel VBA user then you must know how to simplify your … Read more

We are Covering below Topics:   What are the Loops and Why do we need them in programming? For Next Loop with different solutions Which solution is the best one? Art of writing Nested Loops & Fundamentals behind it. Let us Begin: 1.What are Loops & Why do we need them? If I want to … Read more

We are Covering below Topics on Variables: What are Variables in VBA? How do we define Variables? What are the various Data Types? Special Case Study on VARIANT Data Types (Why and Why not?) Why Variables are important in VBA? Option Explicit – What is it  Frequently asked Interview Questions   1. What are Variables? … Read more

Dear reader, A warm Welcome to you! Thank you for visiting this page. I welcome you in this our very first chapter which is Introduction to Macros/VBA. If you are a beginner you are on the right page. I am Ajay Parmar and I am teaching VBA for than a decade now. I love VBA … Read more