作者:墨鱼轩869 | 来源:互联网 | 2023-07-26 14:44
IamnewtoExcelmacros.Ihavesomecolumnswithheadingsscatteredinmanysheets.Iwouldliket
I am new to Excel macros. I have some columns with headings scattered in many sheets. I would like to type a heading in some column which has the cursor and have the column with that heading copy-pasted to the column with the cursor.
我是Excel宏的新手。我有一些标题分散在许多表格中的列。我想在某个列中键入一个带有光标的标题,并将带有该标题的列用光标复制粘贴到该列。
Is it possible to do this by recording a macro? How? If not, how do I do it programmatically?
是否可以通过录制宏来完成此操作?怎么样?如果没有,我该如何以编程方式进行?
2 个解决方案