自动过滤器和复制行

问题描述

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

谢谢。

解决方案

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.

解决方案

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