Hi,

I'm trying to write a quick code that will loop the auto fill function.

I have a sheet w/ two columns, in column A there is data every few rows (rows in between are blank); number of rows in between vary. In column b, there is data in each cell

Is it possible to have a code that allows me to auto fill all the blanks w/ the content in the first row before the blanks? (w/o VBA i would double click to autofill, click next cell in a w/ data, and repeat)

All autofill VBA codes I've seen relate to specific cells - for this exercise, the cells being filled will differ as we move down the column

The below code allows me to offset a range by 1, this would be the last line in my loop:
Cells(Selection.Row + Selection.Rows.Count, Selection.Column).Select

Thank you!