What is the Shortest way to refer the filtered records in an excel table?

[prabha_friend]

Currently I'm using listobjects(1).databodyrange.columns.cells.specialcells(xlcelltypevisible)

But I suspect there must some easier way to directly access the filtered cells. Isn't it? Why so?

 

[AlphaFrog]

For what it's worth, you probably don't need the .cells reference.

listobjects(1).databodyrange.columns.specialcells(xlcelltypevisible)