by Ilker | Oct 11, 2018 | Excel Macros, Excel Tips & Tricks
Named ranges with #REF! error occur when there is a ‘reference’ error. This usually happens when the cell or range itself is removed. For example, if there is a named range that refers to cells in Sheet1!B3 and you delete an entire row, column, or...
by Ilker | Oct 10, 2018 | Excel Macros, Excel Tips & Tricks
Comparing data row by row manually can be a tedious process if done manually. Let us show you how to compare two rows in Excel using VBA and automate this process. How to compare two rows in Excel using VBA VBA has a built in function called StrComp that can...
by Ilker | Oct 10, 2018 | Excel Macros, Excel Tips & Tricks
Comparing columns of data manually is not a realistic approach when working with large data sets. Let us show you how to compare two columns in Excel using VBA and automate this process. How to Compare two Columns in Excel VBA has a built in function called ...
by Ilker | Oct 9, 2018 | Excel Macros, Excel Tips & Tricks
Excel doesn't do as good of a job as some text editors when it comes to spellchecking, and we know how frustrating this can be. Let us show you how to highlight misspelled cells in Excel using VBA. Spelling check feature has been a staple in Microsoft Office products...
by Ilker | Oct 9, 2018 | Excel Macros, Excel Tips & Tricks
Finding cells with errors can be tricky, especially in large workbooks. In this article we’re going to show you how to display cell formulas in Excel that contain errors using VBA. How to display cell formulas in Excel that have errors VBA has predefined types...
by Ilker | Oct 8, 2018 | Excel Macros, Excel Tips & Tricks
Named ranges are very useful when creating Excel models. However, it can get pretty hard to track what named range belongs where as your model grows. Highlighting them on your worksheets can help you identify their properties easily. In this article, we’re going...
by Ilker | Oct 3, 2018 | Excel Macros, Excel Tips & Tricks
Users entering data into the wrong cells or changing existing formulas can make data collection a tedious process. However, you can prevent users from going outside the intended boundaries by disabling certain sections of your workbook. In this article, we’re...
by Ilker | Oct 3, 2018 | Excel Macros, Excel Tips & Tricks
The common ways of locking or hiding tabs in a workbook can be easy to reverse for many users. Using VBA code to do this is considered a better way to do this, if you are familiar with macros. In this article, we’re going to show you how to...
by Ilker | Oct 3, 2018 | Excel Macros, Excel Tips & Tricks
Keeping your data and calculations on separate tabs is easy for an organized structure, but too many tabs in a workbook can become overwhelming quickly. In this article, we’re going to show you how to alphabetize Excel worksheets in ascending or descending...