I thought about iterating through the workbook names, but the same
names appear on different worksheets within the workbook. There didn't
seem to be a consistency in the "Name" attribute -- the first time it
is defined, it has no sheet name component, but all of the others do.
I suppose I can pick up the sheet name from one of the other attributes
instead (e.g. "RefersTo").

I was hoping there was an existing method to just pick them up from a
given worksheet.

Ah, well -- thanks for the code!

On Nov 6, 12:51 pm, "RB Smissaert"
wrote:
Something like this will do it: