@snb --

Actually I was

1. Yours fails if the 'Name to Be' in row 1 will not be a valid name

2. Yours 'hard codes' the RefersTo range so that is data is added or deleted, the named range doesn't reflect the changes


I just prefer my approach.