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

By | June 22nd, 2018|Categories: Excel Macro, Excel Macro Basics, Excel Macro Beginner, Excel Macro Tutorial, Interesting VBA Functions, New to Excel Macro ?, Popular Articles|Tags: , , , |

Dear Friends, Here in this article, I have tried to consolidate some most useful and more frequently used excel macro with examples. This is part 1 where I have provided 20 Excel Macros related to workbook and worksheets. Remaining 20 Excel Macro examples will be followed in my next article [...]

Join The 100,000+ Satisfied Avada Users!

BUY AVADA NOW!