VBA in Excel

How to Reverse Rows in Excel (4 Easy Ways)

Surprisingly, you may not find any inbuilt option to reverse a set of data in rows in Excel. It needs to be done manually. These are all the methods ...

How to Open Workbook from Path Using Excel VBA (4 Examples)

With Excel VBA you can directly open a workbook from a path. In this article, I will demonstrate how to open a workbook from a path using Excel VBA. ...

Excel VBA to Populate Array with Cell Values (4 Suitable Examples)

Sometimes, you may need to populate an Array with cell values in Excel VBA. Thus, I will explain how to populate an Array with cell values in Excel ...

How to Alternate Row Colors in Excel Without Table (5 Methods)

For the purpose of attracting your data, you can alternate Row colors in Excel without even making a Table. In this article, I will explain how to ...

How to Hide Unused Columns in Excel (5 Quick Tricks)

There are so many built-in Columns in Excel. Most of the time, you don't need to use all those Columns. In such cases, you may hide unused Columns in ...

How to Put Comma After 2 Digits in Excel (9 Quick Methods)

When you want to keep data with many digits then you may need to put Comma after 2 digits for easier understandability in Excel. In this article, I ...

How to Capitalize First Letter of Sentence in Excel (6 Suitable Methods)

Excel is not only for numerical values but also you may need to work with text data. So, if you know how to capitalize the first letter of a sentence ...

How to Make VBA Code Run Faster (15 Suitable Ways)

A Visual Basic Applications (VBA) user knows about the importance of why to make VBA code run faster. In this article, I have explained how to make ...

Auto Sort When Data Is Entered in Excel (3 Methods)

Sorting data automatically in excel is really useful when you are handling a wide range of data. Excel has no definite tool to auto-sort your data. ...

How to Use Select Case Statement in Excel VBA (2 Examples)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. This article ...

How to Use INDEX MATCH with Excel VBA

You can utilize the built-in Excel Worksheet functions such as the VLOOKUP Function, the CHOOSE Function and the PMT Function in your VBA code and ...

6 Best Excel VBA Programming Books (For Beginners & Advanced Users)

Do you often find yourself, doing repetitive tasks over and over again in Excel and wishing that somehow, someway these tasks could be automated? ...

How to Import Data from a Website to Excel?

It is well known that World Wide Web contains huge useful data. However, we have to import the data into Microsoft Excel before doing any kind of ...

Learn Excel VBA Programming & Macros (Free Tutorial – Step by Step)

This is a complete guide on Excel VBA. If you're a beginner user of Excel VBA, you will get your best start here. If you're using Excel VBA for the ...

How to Use VBA OnKey Event in Excel (with Suitable Examples)

While we work in Excel, Excel constantly monitors what we do. Sometimes you may want to perform something when you press a particular keystroke for ...

ExcelDemy
Logo