ModifyVBA to fill to bottom of data

So I figure out how to modify a recorded marco correctly as I have no real experience with vba.

I recorded a marco that fills a formula from row 2 thru 11 that looks like:

Selection.AutoFill Destination:=Range("G2:G11"), Type:=xlFillDefault
    Range("G2:G11").Select

However, there is different amounts of data each time I get a new data set and it'd be great to fully automate this, however I can't figure out how to modify this to fill to the bottom.

Any help would be greatly appreciated.

Thanks