Let pivot table search for last row in column

I've got this code when i recorded making my pivot table, but because
the number of rows can vary, how can i make it automaticly search for
the last (bottom) one?

this is my code:

Please Login or Register  to view this content.