根据相邻列自动填充

I'm looking for VBA code that will autofill data down according to the length of an adjacent column. I know there are a few ways to go about this, but which is best?:I'm looking for VBA code that will autofill dat