Most valuable professional
  • Hot Topics

Excel Fill down a formula in a macro for an undetermined set of rows

Hi there, I was wondering how to fill down a formula in a recorded macro which I tried using the auto fill but this only fills down for the previous amount of data i.e. if I had 6 rows of data it only fills the formulas down for this number even if it changes. My code looks like this: Vlookup_Formulas Macro ' ' Range("T24").Select Sheets("TCM_Blotter").Select

This question generated 18 answers. To proceed to the answers, click here.

This thread is current as of September 1, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel