Transferring one-dimensional arrays with build-in function : Range Value « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Range Value

Transferring one-dimensional arrays with build-in function

 
Sub trans()
    range("A1:A3").value = Application.WorksheetFunction.Transpose(range("A1:C1"))
End Sub








Related examples in the same category

1.Reset value in a range to zero
2.Sum the range
3.Return cell value in a range as an array
4.Change cell A1 and move to cell A2 and change it
5.Clear NonDate Cells