Relative Named Range in Excel

Relative Named Range in Excel

Excel uses absolute references for named ranges by default. While absolute references can cover most scenarios, relative references in named ranges work as relative references do in formulas. This behavior can be useful in some scenarios, but can be a bit tricky! In...
How to Make Excel Change Scope of Named Range

How to Make Excel Change Scope of Named Range

Named ranges have a property named “scope”. Usually, you do not need to adjust this property to use named ranges in Excel. On the other hand, it can become very useful if you have a number of sheets that are identical. The scope concept allows you to use...
How to hide named ranges using VBA

How to hide named ranges using VBA

You might want to hide the named ranges in your workbook to prevent your users to tamper with your calculations. In this article, we're going to show you how to hide named ranges in Excel using VBA. How to hide named ranges using VBA Named ranges are objects in a...
Excel Named Ranges

Excel Named Ranges

Users of all levels have different feelings about Excel named ranges. Some find them cumbersome, while others use them religiously. In addition to allowing quick access to complex references, named ranges can make your formulas a lot easier to read and maintain. Once...