Adding values to a range
Is there a shorthand way to do add a set of different values to a range, as shown in this incorrect
code, which would set E4 to "A31", E5 to "Q12" and E6 to "J13"?
Worksheets("Sheet1").Range("E4:E6").Value = {"A31", "Q12", "J13"}
|