can anyone explain to me clearly what a Relative Named range is in Excel? I know what an absolute range is and how to use but i just can't get my head around a relative named range and an example of when to use it?

much appreciated!