VBA sheet name and range

[help_for_excel]

Hi

My question is: I have excel file with 10 sheets with different name. There is a range name "country" can be on any of the 10 sheet. I want vba code to pop-up mesgbox with "excel sheet name" on which range "country" is located



thanks in advance...please help

 

[MickG]

Try:-

MsgBox ActiveWorkbook.Names("Country").RefersToRange.Worksheet.name
MsgBox ActiveWorkbook.Names("Country").RefersToRange.Address

 

[help_for_excel]

thanks it worked great.