Excel VBA Range

[help_for_excel]

my code is in a below line(runs perfect):
Set rngItems = Sheets("Sheet1").Range("Name_List")

Problem is, I don't want to go into VBA and change every time, rather I want to do it from Excel window only. I wrote this code but it is giving me error.
sheet_loc is a single cell range in excel, where one can put sheet1 or sheet2 etc. and Name_List is range of excel cells on that particular sheet. So basically VBA refers to particular range and that range refers to another range.

Set rngItems = Sheets(Range("sheet_loc")).Range("Name_List")


please tell me how to fix this code....thanks in advance

 

[vaskov17]

Set rngItems = Sheets(Range("sheet_loc").Text).Range("Name_List")

 

[Firefly2012]

What was the error? Number and description please

 

[help_for_excel]

thanks it works great