TheRedCardinal
Board Regular
- Joined
- Jul 11, 2019
- Messages
- 243
- Office Version
- 365
- 2021
- Platform
- Windows
Hi all,
I've loaded the data from a table into an array:
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:
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?
I've loaded the data from a table into an array:
VBA Code:
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:
VBA Code:
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?