Indirect Range in VBA

[ker9]

Hi, I want the value of a named cell to be referenced as a range in vba, like Indirect function. I tried the code below and a few other things but am not able to get it working. Any suggestions?

Please Login or Register  to view this content.

FYI: The range NameSelected is on Sheet1, but the row to hide is on Sheet10.

Thank you.

Edit - this doesn't work either

Please Login or Register  to view this content.

Edit 2 - I got it!

Please Login or Register  to view this content.

[arlu1201]

Thank you for providing the solution. Though next time onwards, please post the solution as a separate post, so its easy to distinguish between the question and the answer.