您可以打开Excel，开始录制宏，做你想做的，然后看看录制的内容的宏。这应该告诉你哪些对象使用和如何使用它们。

You could open Excel, start recording a macro, do what you want, then see what the macro recorded. That should tell you what objects to use and how to use them.