Thanks for the tips.

Regarding autofill, in my experience that seems to be "frozen" when used in the context of a Macro.

To clarify, I am making a Macro that will do numerous things for a colleague (formatting, adding multiple Vlookup formulas, some other formulas, text-to-column breaking, etc). I am trying to make the macro as perfect as possible because this person is not very good with Excel, that is why I was trying to have the "smart" autofill.

When I currently use autofill during the macro it records the number of rows during the time of recording, and does not auto-adjust.

Could be because I am using the record function and just doubleclicking on the formulas to get them to auto-populate?