Storing Text Value From Cell To Array

Hi.
I have some cells with text, example:
Adapter for concrete water tank 150mm FG BSP - 2 "

I would store each text in each cell in a position of an array:

Code:

---

Dim arra (941) As String

arra (a) = Cells (line 2). Text

---

But the stored value is just "."
Could anyone help me?

What does 'line 2' mean? Unless it is some variable (there shouldn't have been a space in the variable name) that contains a number, it isn't clear how you would get a '.' in your array. Maybe you want to post a sample file.

Hi.

i'm solvedthis way

Code:

---

ThisWorkbook.Sheets("INC").Copy Before:=oWks.Sheets(1)

---

Thank you!!