Transfer table to vba array

[KerryFSA]

I have a simple table on worksheet "Table" in Excel. Let's say the table is called "SortTable" and has 8 rows by 4 columns. I want to populate a vba array with the contents of the table. I have seen 3 or 4 ways of doing this. None work for me - I get the error message "Can't assign to array". Here are a couple of examples of how I attempted this. Would appreciate your help. I use "Option Base 1". Thanks very much.

Dim SArray(1 To 8, 1 To 4) As Integer, SortTable As ListObject
SArray = Worksheets("Table").ListObjects("SortTable")

OR
SArray = Worksheets("Table").Range("A1:D8")

 

[Akuini]

Declare sArray as variant & don’t set the dimension.
And since “SortTable” is the table’s name then you don’t need to declare it.
Like this:

Dim SArray As Variant
SArray = Worksheets("Table").ListObjects("SortTable").Range

If you want only the data part (without the header):

SArray = Worksheets("Table").ListObjects("SortTable").DataBodyRange

 

[KerryFSA]

OK, that seems to get the table transferred.
Now, I write the following to pick out a value from the newly created array:

x = SArray(2,1)

and get the error "Expected array."

What's wrong?

 

[Akuini]

That should work, I tried it & it worked.
So I don't know what cause the error.
Can you post the whole code?

 

[KerryFSA]

Thanks for reply.
I will post code tomorrow.

 

[KerryFSA]

I changed SArray to variant. Seems to do the trick.
Won't know for sure until I finish the macro.
Thanks again for your help.