excel vba复制黏贴_如何在Excel VBA中复制行

excel vba复制黏贴

Using VBA to program Excel isn't as popular as it once was. However, there are still plenty of programmers who prefer it when working with Excel. If you are one of those people, this article is for you.​

使用VBA对Excel进行编程并不像以前那样流行。 但是，仍然有很多程序员在使用Excel时更喜欢它。 如果您是其中的一员，那么本文适合您。

Copying a row in Excel VBA is the kind of thing that Excel VBA is really useful for. For example, you may want to have one file of all your receipts with date, account, category, provider, product/service, and cost entered one line at a time, as they occur—an instance of evolving accounting rather than static accounting. To do this, you need to be able to copy a row from one worksheet to another.

在Excel VBA中复制行是Excel VBA真正有用的功能。 例如，您可能希望在所有收据中都包含一个文件，其中日期，帐户，类别，提供者，产品/服务和成本在发生时每次输入一行，这是不断发展的会计而非静态会计的一种情况。 为此，您需要能够将一行从一个工作表复制到另一个工作表。

A sample Excel VBA program that copies a row from one worksheet to another—using only three columns f