Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
mycat is a string in my I column or column 9 (defined as MyCategoryCol)
Export_Info(mycat as string) { ....misc variables. ' Apply my filter. Selection.AutoFilter Field:=MyCategoryCol, Criteria1:=mycat, Operator:=xlAnd ' Count the number of filtered tasks. column_counter = Application.WorksheetFunction.Subtotal(3, Range("I:I")) For i = 1 To column_counter ' The QUESTION buff = Selection.Cells(i, MyQuestionCol) ConBuff = "" For j = 1 To Len(buff) If InfFont(Asc(Mid(buff, j, 1))) = 255 Then MsgBox "Unrecognised characters in Question at line " & i & ", character # " & j & " (" & Chr(InfFont(Asc(Mid(buff, j, 1)))) & "), table entry " & Asc(Mid(buff, j, 1)) ConBuff = ConBuff + "?" Else ConBuff = ConBuff + Chr(InfFont(Asc(Mid(buff, j, 1)))) End If Next j Print #hfile, ConBuff next i .... many more sections of data, but they are all basically the same as this. } THE PROBLEM: When I go through this loop, i always get the cells from the top, even ones that should be filtered. I don't know why this happens. When I filter by "Kids" for example, the 217 rows that have info about the "kids" even though the actual row is at like 21,000 - I start getting entries from row 1, which is usually a different column like "History" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count if on Visible - Filtered | Excel Worksheet Functions | |||
Return filtered tasks | Excel Programming | |||
Filtered Visible Rows & VBA Non-Filtered Rows Displayed | Excel Programming | |||
Repost: Dop to next visible row when filtered? | Excel Programming | |||
Drop to next visible row when filtered? | Excel Programming |