Determine After Filter Row Numbers

[sabrefan1970]

Good Day ...

Is there a way to automaticaly determine the final row number showing after a manual filter operation ? Or maybe getting a list
of the row numbers showing on the screen.

The project requires a macro that loops through only the rows of a filtered list, not all of the rows in the worksheet .

Thanks.

[Richard Buttrey]

Hi,

I generally use something like

lLastRow = Range("A" & Rows.Count).End(xlUp).row

[:) Sixthsense :)]

Use range(Your range Here).specialcells(xltypevisible) option

[sabrefan1970]

Thank you both for the quick reply. Since you both presented the same idea, I'm confident I can get it to work. But my boss has just pulled me onto a different project, so I won't be able to mark solved until tomorrow.

Richard, I think we have met before. Nice to see you again. Sixthsense - nice to meet you.

Rich