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

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

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

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

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...
How to unhide sheets in Excel with VBA

How to unhide sheets in Excel with VBA

You might want to hide or unhide certain sheets in a workbook for security reasons and there are several ways you can do this. In this article, we’re going to show you how to unhide sheets in Excel with VBA.   How to unhide sheets in Excel Worksheets are...
Improving VBA Macro Performance

Improving VBA Macro Performance

Creating macros in Excel can be a difficult task, especially if you’re just starting out. However, Excel thankfully has several features that are designed to help developing macros. For example, calculations automatically update after every action, the status bar...