Resizing table to last row in sheet

[Matlas]

Heya,

I have the following two pieces of code:

For finding the last row in the sheet:

Please Login or Register  to view this content.

For resizing a table:

Please Login or Register  to view this content.

Both work as expected.What I'd like to do now is somehow insert the lastrow inside the second half of the Resize Range paramater, something (logically speaking) like ("$A$7:$K$lastrow"). This obviously won't work, but what would the correct syntax be? Tried looking up, but kept running into xlDowns which is not what I'm aiming for (I specifically need to only resize to the last row with values in the entire sheet).

Many thanks!

[mehmetcik]

Please Login or Register  to view this content.

[Matlas]

Solved. Thanks mehmetcik!