Autofill macro: filling for range whilst there is a value in cell

Hi!

I'm pretty new to macros. I recorded one for an autofill series which basically came out as

Selection.AutoFill Destination:=Range("I2:I8"), Type:=xlFillDefault

However, what I really want is for the range to go from I2 and go down for every cell whilst there is a value in the cell to the left (i.e. I2:End)

Anyone know how this can be done?

Thanks in advance!