VBA Dynamic Range selection

Hi,
I have some macro to do, and I stop in one point. I dunno how to create a massive dynamic ranges for formulas in VBA. Let me show my code so far (this is just a part of the macro)

Please Login or Register  to view this content.

What I need is the macro should activate the Sort, and jump to the last Filled line, after Fill out the blank ones till the end of the table....

OK, so my problem is, I do not know, where should start the formula. I know that the formula should stop at the lastrow... with line like this:

Please Login or Register  to view this content.

How can I set the proper range?

Could anyone help me? that would be awesome.
Thanks in Advance,
Arrabonae

OMG Thanks you very much!!

That's nice Really thank you.