Archive for the ‘named ranges’ Category
Create a dynamic named range using OFFSET
Named Ranges are a powerful tool in Excel – ranges can be used to shorten commonly-used functions and are more user friendly. Yet named ranges refer to absolute cell references. When you’re using a dynamic record list, you’ll need to ensure the named range is also dynamic. Read the rest of this entry »
