I know this is fairly common, but my internet searches have not helped me solve the problem.
I have a formula in "E1" and I want my VBA macro to drag or autofill the formula down to the corresponding last cell that has data in Column D.
I tried this:
Range("E1").Select
Selection.AutoFill...