Should work fine.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Zone" wrote in message
oups.com...
Thank you, Jon. This fills in the last piece of the puzzle. I found
that the workbook in question may not be active when I'm trying to
find the range it. Although I can activate the workbook and then look
for the range's sheet, that's inconvenient and slow in my situation.
So, following your advice, I could apparently use code like

Workbooks("myworkbook.xls").Names("TheName").Refer sToRange.Parent.Name

I haven't actually tested this yet, but seems like it should work.
Regards, James

On Jun 23, 12:10?pm, "Jon Peltier"
wrote:
One more option:

ActiveWorkbook.Names("TheName").RefersToRange.Pare nt.Name

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

"Zone" wrote in message

oups.com...



I have a workbook with several worksheets. Each worksheet has many
named ranges (single-cell ranges, all in row 1). I want to specify a
range name and have my subroutine activate the sheet containing the
range name and select the column containing the range name.
Thanks, James- Hide quoted text -

- Show quoted text -