excel vba 列_Excel VBA：将列标题切换为数字

excel vba 列

It's Friday, and your brain is almost full, but let's try to cram a little bit of Excel VBA in there before the weekend. We've talked about the Excel Column Headings before, and seen how to change the Reference Style setting from R1C1 (Numbers) to A1 (Letters).

现在是星期五，您的大脑几乎已满，但是让我们尝试在周末之前在其中塞满一点Excel VBA。 我们之前已经讨论过Excel列标题 ，并了解了如何将“参考样式”设置从R1C1(数字)更改为A1(字母)。

That setting is pretty well hidden, and it's a bit of a pain to switch on and off. We'll create a macro that will let us quickly switch from A1 to R1C1, or from R1C1 to A1.

该设置隐藏得很好，打开和关闭它有点麻烦。 我们将创建一个宏，使我们能够快速从A1切换到R1C1，或从R1C1切换到A1。

步骤1：记录宏以将列标题切换为数字 (Step 1: Record a Macro to Switch Column Headings to Numbers)

To see the Excel VBA code that changes the setting, we can use the Excel Macro Recorder.

要查看更改设置的Excel VBA代码，我们可以使用Exc