SpecialCells(xlCellTypeVisible).Rows.Count不返回正确的可见行数 [英] SpecialCells(xlCellTypeVisible).Rows.Count Doesn't return correct visible Rows Count
问题描述
嗨每一个,
我在表名"tSource"中有以下行数据。下面:
I have following rows data in a Table name "tSource" below:
我在VBA中应用以下过滤器
I am applying folowing filter in VBA
范围("tSource")。AutoFilter 2,"= FS *"
Range("tSource").AutoFilter 2, "=FS*"
cCnt = Range(" tSource")。SpecialCells(xlCellTypeVisible).Rows.Count
cCnt = Range("tSource").SpecialCells(xlCellTypeVisible).Rows.Count
过滤器正确应用,我可以看到所有可见的行应用于条件,但Count为可见行返回错误的数字。不知道为什么。
The filter apply correctly and I can see all the Visible rows apply to criteria but the Count return me wrong number for visible rows. Don't know why.
推荐答案
你好了,
我们有Visual Basic for Applications论坛会更好地适应这个问题。我会在那里移动这个帖子以获得更多的回复。
We have Visual Basic for Applications forum would fit this question better. I will move this thread there for getting more responses.
谢谢,
这篇关于SpecialCells(xlCellTypeVisible).Rows.Count不返回正确的可见行数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!