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...
by Ilker | Oct 12, 2018 | Excel Macros, Excel Tips & Tricks
You can remove characters by replacing a character with an empty string (“”). Although you can do this by going through all such cells in a selection or specified range using Find & Replace, in this article we’re going to show you how to remove...
by Ilker | Oct 11, 2018 | Excel Macros, Excel Tips & Tricks
Printing values instead of the formulas themselves can help protect your IP or prevent users from changing them. In this article, we’re going to show you how to have Excel convert formula to value using VBA. How to have Excel convert formula to value We...
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 spell check in Excel using VBA. Spelling check feature has been a staple in Microsoft Office products for a...
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...
