How to define a range in another worksheet ?

Hello everybody !
First at all, please apologize my english.

I have a file with up to 40 worksheets, and I want to find a way to define a range in a WorkSheet using a string as the name of the worksheet.

Do you know how to do it guys ?

Do you mean this:

Please Login or Register  to view this content.

Thank you a lot, it works. Do you know if I can use myRange in a Vlookup function ?

Please Login or Register  to view this content.