Forum Discussion

Copper Contributor

Apr 13, 2023

Help with vba formula to autopoulate

ActiveCell.FormulaR1C1 = "=DAYS(TODAY(),RC[-1])" Range("R2").Select Selection.AutoFill Destination:=Range("R2:R" & Range("E" & Rows.Count).End(xlUp).Row) Range(Selection, Selection.End(xlDown)).Se...

Macros and VBA

Michael_Beach

Copper Contributor

Apr 13, 2023

To make it stranger, the formula appears to have correctly pasted, but it did not execute. It just copied the results of the formula from the original cell instead of completing the formula.