Is there any way to turn these two WITH statements into an Array so that both cells are done together?
I've tried the below, but nothing happens.
Thanks for any assistance.
Code:
With Range("F1")
.FormulaR1C1 = "=""Used "" & Text(Now(), (""m/d/yy""))"
End With
With Range("G1")
.FormulaR1C1 = "=""Received "" & Text(Now(), (""m/d/yy""))"
End With
I've tried the below, but nothing happens.
Code:
Sub test2()
With Array(Range("F1,G1").FormulaR1C1 = "=""Used "" & Text(Now(), (""m/d/yy""))", FormulaR1C1 = "=""Received "" & Text(Now(), (""m/d/yy""))")
End With
End Sub
Thanks for any assistance.