Is there a way to expand my table to the last row with a value in it?

So let's say I paste something on my table using advance filter...but when I paste my values into the table the table doesn't expand automatically. Is there a way that I can just write a VBA code to tell it to expand the table to the last row with a value in it?