I am trying to apply a formula to a range:
Rw = Range("A65536").End(xlUp).Row
With Range(Cells(2, 17), Cells(Rw, 17))
.FormulaR1C1 = "=offset($A$1,row(),14,1,1)"
end with
Why am I getting an error with the above? After I get the above to work, I want to modify the formulat to the following:
.FormulaR1C1 = "=text(offset($A$1,row(),14,1,1),""mmm-yy"")"
(convert the date in column 14 into "mmm-yy" format and put this in column 17)
Thanks.
ew
Rw = Range("A65536").End(xlUp).Row
With Range(Cells(2, 17), Cells(Rw, 17))
.FormulaR1C1 = "=offset($A$1,row(),14,1,1)"
end with
Why am I getting an error with the above? After I get the above to work, I want to modify the formulat to the following:
.FormulaR1C1 = "=text(offset($A$1,row(),14,1,1),""mmm-yy"")"
(convert the date in column 14 into "mmm-yy" format and put this in column 17)
Thanks.
ew