VBA工作表子在另一个工作表中创建命名范围

I have a private sub that needs to create named ranges within another worksheet. It needs to stay a worksheet function, as it is a I have a private sub that needs to create named