How to delete named range Excel using VBA

How to delete named range Excel using VBA

Managing and removing named ranges in Excel can be a challenging task as you would have to do this one by one for each field. We’re going to show you how to delete named range Excel using VBA with one click.How to delete named range ExcelEach named range is an...
How to prevent Save As with VBA

How to prevent Save As with VBA

This article shows you How to prevent Save As with VBA.You can control your workbook’s events like opening, closing or saving by VBA. Events for Excel’s native objects are built in and ready to use. To prevent Save As event, the address is Workbook...
How to find in Excel if cell is blank using VBA

How to find in Excel if cell is blank using VBA

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....
How to make Excel capitalize first letter using VBA

How to make Excel capitalize first letter using VBA

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...
How to convert selection to Excel lowercase using VBA

How to convert selection to Excel lowercase using VBA

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

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

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

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

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