Setting up dynamic named ranges in code

Originally Posted by j_Southern

The ranges will only ever change by increasing the number of rows.

Isn't that the purpose of using COUNTA($A:$A) in your original formula?