How to Delete a Sheet in Excel Using VBA
Deleting worksheets in Excel is a fairly easy task. All you need to do is just right-click on the sheet’s name at the bottom of the Excel window and hit …
Excel VBA / Macros
How to Select Every Other Cell in Excel (Or Every Nth Cell)
If you’ve ever tried selecting alternate cells or cells in a particular pattern in Excel, you would know that this is not as easy as it seems. Well, if it …
How to Remove Apostrophe in Excel (3 Easy Ways)
You might have come across Excel documents created by someone else that contains the apostrophe symbol in front of text, numbers, or dates. You might have also noticed this happening …
How to Auto Format Formulas in Excel (3 Easy Ways)
When working with formulas, there is always a possibility that someone (or even you) may delete a cell (or clear the contents of a cell/range) that has formulas in it. …
How to Unhide All Rows in Excel with VBA
If you’re in the habit of hiding rows in Excel, you may also sometimes, have a need to unhide all rows in a worksheet in Excel. In this tutorial, I …
Using Application.EnableEvents in VBA in Excel (Explained with Examples)
Application.EnableEvents is a property in Excel VBA where you can specify whether you want events to take place when the VBA code is running or not. An event is usually …
How to Clear Contents in Excel without Deleting Formulas
Excel allows you to clear content in the worksheets selectively. So, you can clear the contents in all the cells except the ones that have formulas. This can be useful …
How to Delete a Comment in Excel (or Delete ALL Comments)
Comments in Excel are great when you’re working with multiple people and need to tag a few cells with some important notes. And with comments, you can have multiple people …
How to Extract URL from Hyperlinks in Excel (Using VBA Formula)
If you work with data copied from the web into Excel, you would often get a dataset that has hyperlinks in it. For example, below is an example dataset where …