usedrange when applied to a pivot table in a Sheet

[drom]

Hi and Thanks in advance

I am feeding a table thanks to a macro, this table may have 40 rows or 20000 rows
I have a Pivot table using this table as data source

When feeding the table I clean always the previous data, and then I refresh the pivot table
(I am using macros because I am doing many calculations and...)


When the Pivot table is been refreshed, I use:

Sheets(Sheet035.Name).PivotTables(1).PivotFields("Check").CurrentPage = "YES"

Sometimes the pivot table shows only 20 rows, sometimes many more rows
but the Sheets(Sheet035.Name).usedrange.address is always huge

Do I need to reset, delete from Rows(250:15000) to avoid size problems??

If my Pivot table Sheet has only 5 columns with Info and usually no more than 200 rows
How can I eg:
-get as Usedrange only A1:J200 ???

At present I get always > J5000