Re-Find Last Row in Spreadsheet while Loop is being executed and data grows

The code I have sorts, filters, and groups like items. The issue I am having is the finalrow declaration before the beginning of the For loop sets the final row of the data as what it is before the loop runs. While the loop runs, it inserts blank rows in between the grouped items. This causes the dataset to get spread across more and more rows. The problem is because of the initial declaration of where that last row is, it won't sort or filter anything past that row. How do I get it to re-calculate the last row of data as the program executes? I've tried a few things, like inserting the finalrow declaration in to the If Then loops, but nothing has worked right so far. Thanks!

Please Login or Register  to view this content.

hi nickv02, can you post original data sample and result you need to obtain?

Actually Pichingualas' response worked perfect. Everything sorts correctly now.