by Ilker | Nov 6, 2018 | Excel Macros, Excel Tips & Tricks
Finding all comment fields inside a workbook might be a challenge if you’re not sure where they might be hiding. Let us show you how to highlight Excel comment using VBA to find them quickly! How to highlight Excel comment using VBAVBA has some predefined types...
by Ilker | Oct 26, 2018 | Excel Macros, Excel Tips & Tricks
Be it for troubleshooting formula errors or data integrity, you might find yourself trying to identify those cells going through the entire workbook. In this article we’re going to show to find in Excel if cell is blank using VBA and automate this process....
by Ilker | Oct 26, 2018 | Excel Formulas
AVERAGIFS function can calculate the average in a range of cells, based on a criteria. In this guide, we’re going to show you how to use the AVERAGIFS function and go through some examples, as well as error handling methods. Supported versions (Windows) Excel 2007 and...
by Ilker | Oct 26, 2018 | Excel Formulas
COUNTIFS function can count the values in a range of cells, based on some criteria. In this guide, we’re going to show you how to use the COUNTIFS function and cover some examples and error handling methods. Supported versions (Windows) Excel 2007 and above (Mac)...
by Ilker | Oct 24, 2018 | Excel Formulas
SUMIFS function can sum up the values in a range of cells, based on some criteria. In this guide, we’re going to show you how to use the SUMIFS function and cover some examples and error handling methods. Supported versions (Windows) Excel 2007 and above (Mac) Excel...
by Ilker | Oct 22, 2018 | Excel Tips & Tricks
Lining up the decimal places is the desired structure for some applications, especially in a finance context. With this, you can make the decimal portion of numbers start from the same place, regardless of how many digits the consist of. You can do this using...
by Ilker | Oct 18, 2018 | Excel Macros, Excel Tips & Tricks
More often than not, to save time or for the sake of laziness, people enter data in all lowercase or all uppercase. Transforming this type of data into the proper format can be a serious headache. Let us show you how to make Excel capitalize first letter using VBA to...
by Ilker | Oct 18, 2018 | Excel Macros, Excel Tips & Tricks
Is changing the all letters to lowercase manually taking too much time? Let us show you how to convert selection to Excel lowercase using VBA and automate this process. Both Excel and VBA have a function to do this. Both functions use a single argument which is the...
by Ilker | Oct 12, 2018 | Excel Macros, Excel Tips & Tricks
Changing lowercase characters into uppercase is a pretty tedious task if you’re doing it manually. In this article, we’re going to show you how to make Excel change case to uppercase using VBA Both Excel and VBA have a function to do this. Both use a...
