如何用VBA重新定义命名范围?

I have a named range called "X" which is 1000 rows and I want to dynamically reduce this to 100.I have a named range called "X" which is 1000 r