Basically, I want to retrieve the contents located in the Name cell.. if you use the drop down box, you will see defined names that the work sheet has already but normally, the box will show the name of the cell your currently on.. I want to be able to select the name box and copy that information for other use..