How to convert selection to Excel lowercase using VBA

How to convert selection to Excel lowercase using VBA

by | Oct 18, 2018

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...
How to make Excel change case to uppercase using VBA

How to make Excel change case to uppercase using VBA

by | Oct 12, 2018

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...
How to remove characters in Excel using VBA

How to remove characters in Excel using VBA

by | Oct 12, 2018

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...
How to have Excel convert formula to value using VBA

How to have Excel convert formula to value using VBA

by | Oct 11, 2018

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...
How to compare two rows in Excel using VBA

How to compare two rows in Excel using VBA

by | Oct 10, 2018

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...
How to find named ranges in Excel by highlighting them using VBA

How to find named ranges in Excel by highlighting them using VBA

by | Oct 8, 2018

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...
How to lock a cell in Excel formula using VBA

How to lock a cell in Excel formula using VBA

by | Oct 3, 2018

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...
How to alphabetize Excel tabs using VBA

How to alphabetize Excel tabs using VBA

by | Oct 3, 2018

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...