Loaded a table into an array - how do I get it back out?

[TheRedCardinal]

Hi all,

I've loaded the data from a table into an array:

TableArray = WS1.ListObjects(1).DataBodyRange

I then manipulate the data inside the array using various loops.

Now I want to put it back in the table. The size can never change.

I tried this:

WS1.ListObjects(1).DataBodyRange = TableArray

But obviously from the thread, this hasn't worked!

Is there a simple way to drop the result of the array back into the table?

 

[JEC]

That is actually the right way

 

[Fluff]

How about

   Ws1.ListObjects(1).DataBodyRange.Cells(1).Resize(UBound(TableArray), UBound(TableArray, 1)).Value = TableArray

 

[JEC]

How is the rest of your code? The method you showed has to work

 

[TheRedCardinal]

That is actually the right way

Yes thanks!

I should probably check that my "manipulation" steps actually worked and altered the array, before worrying about the output!

 

[JEC]

Nice good luck!