I was trying to get the defined names for a certain range.

"Mike H" wrote:

Perhaps I'm missing something but isn't it F3 and paste list

Mike

"ranswert" wrote:

Is there a way to write a procedure that will pull all the cell names off a
range of cells and put it into a list?
Thanks