How about this, if you are using the names collection of the workbook:

?thisworkbook.Names(1).RefersToRange.Worksheet.Nam e

Jeff

"MattShoreson"
wrote in message
news:MattShoreson.28zjd1_1149605752.6187@excelforu m-nospam.com...

Say I have 3 sheets each with a named range on.

I know I can use the collection to cycle thru all names...

But how can I work out the sheet on which the name is?

Any sort of pointer would help!

thanks,
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile:
http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=548988