By | February 10th, 2019|Categories: Excel Formula, Excel Functions, Excel Macro, Excel Tips|Tags: , |

Excel Trick to Calculate MOD of Big Numbers. This article is all about MOD function in Excel. Every aspect of MOD function is covered here in this article. At the end of this article, I have also explained a VBA code to calculate MOD of large numbers. I have also [...]

By | September 25th, 2018|Categories: Excel Functions, Excel Macro, Popular Articles, User Defined Function|Tags: , , , |

First of all, wouldn't it be great if we have a built in function in Microsoft Excel to Convert Numbers to Letters. It means, simply, by using a formula in excel, I could Spell Numbers in Words. In banking or accountancy, this is used to write grand total amounts. Amounts [...]

By | September 9th, 2018|Categories: Excel Macro Beginner, Excel Macro Tutorial|Tags: , , , |

Early and Late Binding is a common phenomena across computer programming languages. In simple terms, Binding means - how and when methods or properties of an Object are compiled and checked. In case of Excel VBA [COM - Component Object Model] - this occurs when you are trying to automate [...]

By | September 5th, 2018|Categories: Excel Functions, Excel Macro, Excel Tips|Tags: , , |

Dear Reders, In this article, I am going to teach you What is Regular Expression (RegExp or RegEx)? and how RegEx is used in Excel VBA programming. You will also learn usage of Regular Expressions in Excel VBA with some example VBA code. You can also find some simple regular [...]

Comments Off on Regular Expression and its usage in Excel VBA

By | July 4th, 2018|Categories: Excel Macro, Excel Macro Beginner, Excel Macro Tutorial, Excel Tips, Popular Articles|Tags: , , , |

Dear Friends, This is a very simple yet powerful Excel VBA tip for you. Many a times before sending your workbook with Excel VBA Macro code in it, you want to save your workbook without any VBA code in it. Therefore here in this article, I will show you - [...]

By | June 28th, 2018|Categories: Excel Macro, Excel Macro Beginner, Excel Macro Tutorial, Popular Articles|Tags: , , , |

Dear friends, As you see this is the second and last part of the tutorial 40 Useful Excel Macro [VBA] examples. In previous article i had published the first 20 examples. Download a FREE Excel Workbook with all 40 Examples At the end of this article, you will have a [...]

Join The 100,000+ Satisfied Avada Users!

BUY AVADA NOW!