Does this solution for non volatile dynamic named range work?

Shg,
If a non-volatile function has the whole sheet as its precedents, how is that different than a volatile function?

An alternate would be =INDEX(Sheet1!$B:$B, 12, 1):INDEX(Sheet1!$B:$B, CodeCount, 1)