BenChod
07-12-2017, 07:45 AM
Hi all -
I have the following two lines of code where I want to copy a formula all the way down to the last row in the column. The problem I am facing is that the formula is being copied to the first to rows in column M. Hoping someone can take a quick look and let me know what I am doing wrong.
lastrow3 = Sheets("QC").Range("M" & Rows.Count).End(xlUp).Row
Range("M3:M" & lastrow3).Formula = "=DATEDIF(RC[-1],TODAY(),""d"")"
I have the following two lines of code where I want to copy a formula all the way down to the last row in the column. The problem I am facing is that the formula is being copied to the first to rows in column M. Hoping someone can take a quick look and let me know what I am doing wrong.
lastrow3 = Sheets("QC").Range("M" & Rows.Count).End(xlUp).Row
Range("M3:M" & lastrow3).Formula = "=DATEDIF(RC[-1],TODAY(),""d"")"