const filteredRangeAColumn =
ActiveSheet.AutoFilter.Range.Columns('A').SpecialCells(xlCellTypeVisible)
console.log('Count =', filteredRangeAColumn.Count)
console.log('Value =', filteredRangeAColumn.Value)
console.log('Each...')
filteredRangeAColumn.Each(cell => {
console.log(cell.Text)
})
截图: