• Hot Topics

Excel Autofill formula not working

Hello I am using the below auto fill code but for some reason it is not filling the formula to the last cell. Code: Sheets("name2").Select Range("O1").Select ActiveCell.FormulaR1C1 = _ "=RC[-14]&RC[-13]&RC[-12]&RC[-11]&RC[-10]&RC[-9]&RC[-8]&RC[-7]&RC[-6]&RC[-5]&RC[-4]&RC[-3]&RC[-2]&RC[-1]" Range("O1").Select Selection.AutoFill Destination:=Range("O1:O" & Range("A" & Rows.Count).End(xlUp).Row) The code is suppose to auto fill the formula in column O down to the last cell of the sheet in accordance to the la

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

This thread is current as of August 20, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel