VBA macros help in simplifying and extending the Excel functions. Besides, they also help when it comes to automation. But sometimes, they throw some error messages when they experience a problem. Although these Excel error messages can be nagging they are actually helpful since they tell you something is not working as it should. One […]
How to Fix VBA Runtime Error 400 in Excel? Read More »
You can easily count the number of times a value appears in Excel using formulas. But there are other options that you can use such as Addins and VBA codes. By using an add-in, you get even to highlight the duplicate values. In this article, I will guide you step-by-step step on how to count
How to Count the Number of Times a Word Appears in Excel Read More »
Excel does not feature an inbuilt CAGR function. Luckily, there are various ways you can use to get a solution. For instance, you can customize your own formula or combine inbuilt existing formulas to achieve the same results. This article is a step-by-step guide on calculating CAGR in Excel. What is CAGR? Compound Annual Growth
How to Calculate CAGR in Excel Read More »
Excel is a powerful tool but it has its limitations. For example, it can only display a maximum of 1,048,576 rows and 16,384 columns. Therefore, whether you are opening an Excel sheet or a CSV file, the limit remains the same. What if you want to open a large CSV file with more than 1,048,576
How to Open a Large CSV File Read More »
Microsoft Excel is a powerful program when it comes to automation. If you have a list of files in a folder and want to copy in Excel then doing it manually could take ages. Luckily, Excel can access files and folders in your system. You can use it to get all the information that you
How to Get List of File Names in a Folder using Excel Read More »
Excel only displays one worksheet at a time in a given window. Therefore, comparing two workbooks or worksheets becomes a challenge. Luckily, there are multiple ways that can be used to solve this challenge. From the use of formulas, to Pivot Tables or Even third-party Addins, you can easily navigate this challenge In this tutorial,
How to Compare two Excel Sheets or Workbooks for Differences Read More »
We use timestamps when we want to track activities. It is a type of data type that determines the date and time. In our article below, we illustrate the different methods you can use to insert a timestamp when a cell changes in Excel Using a keyboard shortcut 1. Select the cell where you need
How to timestamp when a cell changes in Microsoft Excel Read More »
Run Time Error 9 VBA Subscript out of range is one of the most common errors. But it’s actually one of the most useful error messages. Excel uses this error to inform you that a cell, range, worksheet, or workbook that you have referenced does not exist. Therefore it’s out of range. In this article,
Run Time Error 9 VBA Subscript out of Range Read More »
Excel is a powerful spreadsheet program. Sometimes it throws error messages to help users understand why a certain action didn’t work as intended. In most cases, the errors are associated with functions but there are others that cut across all features. One of the most common errors in Excel is the #####. If you are
How To Solve the ##### Error in Excel Read More »
