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!
Bookmarks