Excel resources
Excel Macros
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 3 of 4 · 33 articles
How to delete named range Excel using VBA
Managing and removing named ranges in Excel can be challenging. Let's show you how to delete named range Excel using VBA with one click.
How to prevent Save As with VBA
Learn how to prevent Save As with VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to find in Excel if cell is blank using VBA
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
To save time or for the sake of laziness, you find data in uppercase or lowercase. Let's show you how to make Excel capitalize first letter.
How to convert selection to Excel lowercase using VBA
Learn how to convert selection to Excel lowercase using VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to make Excel change case to uppercase using VBA
Changing lowercase characters into uppercase is a tedious task to do manually. Let's show you how to make Excel change case to uppercase.
How to remove characters in Excel using VBA
Although you can replace characters with Find & Replace, we will show you how to remove characters in Excel using VBA to automate it.
How to have Excel convert formula to value using VBA
In this article, we're going to show you how to have Excel convert formula to value using VBA, to protect your formulas.
How to compare two rows in Excel using VBA
Learn how to compare two rows in Excel using VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.