I have a spreadsheet that someone gave me. It has formulas in columns A thru J and data in columns K thru Y.
I would like to be able to autofill columns A thru J when the amount of rows in columns K thru Y changes (gets overwritten).
So far all I have is the following which just selects the last row of columns A thru J.
Range(Selection, Selection.End(xlToRight).Offset(0, 1)).Resize(1, 10).Select
How do I get the autofill part? Or, if there is a different way than autofill, that's fine too.