自动过滤器和复制行 [英] Autofilter and Copying Rows

问题描述

我正在使用Excel 2003.首先，我的程序自动过滤一个特定数字的列。在这种情况下，我们可以假设这个数字是30.然后我试图让程序复制我自动过滤的列中包含30的每一行。我想让它设置一个Do ... Loop Until IsEmpty循环，这样它就会复制每个可见的行（这些行将是自动过滤列中包含30的行。问题是当我运行程序时，程序还会复制由于自动过滤而隐藏的行。如何解决此问题？

谢谢。

解决方案

通读此前一个帖子......

宏仅复制可见的已过滤行
看看是否有帮助。

如果你需要进一步的帮助nce，回复，我会看看我能为你做些什么。

Hi,

 

I am using Excel 2003.  First my program autofilters a column for a specific number.  In this case, we can assume that this number is 30.  I am then trying to get the program to copy each row that contains 30 in the column that I have autofiltered.  I want to have it set up with a Do...Loop Until IsEmpty loop such that it copies each visible row (these would be the rows that contain 30 in the autofiltered column.  The problem is that when I run the program, the program also copies the rows that are now hidden due to the autofilter.  How do I fix this problem?

 

Thanks.

解决方案

Read through this previous thread...

Macro to only copy visible filtered rows
and see if it helps.

 

If you need further assistance, reply and I'll see what I can do for you.

 

这篇关于自动过滤器和复制行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！