I'm trying to count visible number of cells in a specific column after auto filter in macro. Here's the code I'm trying. I get 389 as the final answer, whereas the visible cells are only 7. othdet1 is a range and othdet is an integer.


Set othdet1 = Sheets("OTHERS").Range("I4:I400")

othdet = Range("i4:i400").SpecialCells(xlCellTypeVisible).C ount

Sheets("OTHERS").Range("N4") = othdet

The range I4:i400 is a result of an auto filter from parent sheet.

where am I going wrong?
Thanks in advance