@Stephen Doh. I wouldn't care if I hadn't actually been thinking row, column and still I got it wrong.
–
ColAug 17 '11 at 17:47

1

yea, that's going to end up with "Apples" "Bananas" or the like as the range name, not "FruitList" That is what you asked for ('set the name box of E5 to the contents of D5') but I see how we looked at the image instead of that sentence. Oops :-)
–
StevenVAug 17 '11 at 19:29