VBA: How to get current region from filtered data?

user_8263656 0
Viewed 4303

I want to figure out how I can get data after filtering to variant object. When I use this:

table = ActiveSheet.Range("A1").CurrentRegion

I'm gettig all data but I want only filtered.

Workbooks screen shot: enter image description here

variant filtering range vba excel
2 Answers
Related