Question: I was trying to add a server by clicking in the *Servers* view on *"No servers are available. Click this link to create a new server..."*:

[![here](https://i.stack.imgur.com/hZGIh.jpg)](https://i.stack.imgur.com/hZGIh.jpg)

...and choosing the server that were available in a list. However, among the list the server I wanted to install was not to be:

[![seen](https://i.stack.imgur.com/dNEhj.jpg)](https://i.stack.imgur.com/dNEhj.jpg). 

Earlier, I downloaded the binary version of it found at <https://wso2.com/integration/previous-releases/> and installed it at `C:\Program Files\WSO2\Enterprise Integrator\6.4.0` as per recommendation of the product's guide.

My question is that why is there no WSO2 Enterprise Integrator 6.4.0 in the "New Server" window and how do I make sure that it appears?

Answer: 
On [this site](http://www.cpearson.com/excel/ArraysAndRanges.aspx) I found this useful little piece...

```
Dim Destination As Range
Set Destination = Range("K1")
Destination.Resize(UBound(Arr, 1), UBound(Arr, 2)).Value = Arr

```

You can transpose the array when writing to the worksheet:

```
Set Destination = Range("K1")
Destination.Resize(UBound(Arr, 2), UBound(Arr, 1)).Value = Application.Transpose(Arr)

```
The underlying problem is that 1D array corresponds to a *row* in the sheet. So you can put

```
Range("A1:E1") = table

```

and it works fine.

If you want to put your array into a column, the easiest way is to use transpose as mentioned by @Paul:

```
writeArray = Application.WorksheetFunction.Transpose(table)

```

which gives you a 2D array with five rows and 1 column.

```
Sub test2()
    Dim table(0 To 4) As Variant
    Dim writeArray() As Variant

    table(0) = 0
    table(1) = 1
    table(2) = 2
    table(3) = 3
    table(4) = 4

    writeArray = Application.WorksheetFunction.Transpose(table)

    Debug.Print ("ubound=" & UBound(writeArray, 1))
    Debug.Print ("ubound=" & UBound(writeArray, 2))

    Range("A1:A5") = writeArray
    Range("A1:E1") = table
End Sub

```

[![enter image description here](https://i.stack.imgur.com/6mjuX.png)](https://i.stack.imgur.com/6mjuX.png)