View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon[_7_] Jon[_7_] is offline
external usenet poster
 
Posts: 4
Default 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"}