I have a worksheet that uses named ranges in it's formulas.

Is there a way to set the named range to be realative to the curent sheet?

Example currently one named range is

B_Class_Desc=Sheet1!$AJ$3

what I would like to do is have something like this
B_Class_Desc=CurrentSheet!$AJ$3

But since CurrentSheet! is supported is there a way to simulate it?

Thanks