I would like to programmatically set the name box of a cell in a worksheet I'm working on, either through a formula or through a macro. The end point is that I don't want to set it by hand.
In my case based on the value in (say) cell D5 set the name box of E5 to the contents of D5.
I haven't seen a reference that would let me do this simply, so I suspect it's something that might have to be set through VBA.
Has anyone done this or can advise how to do this?