Help with Array -> Range assigment

[Roopher]

Hello there!

I am kind of baffled with an array assignment task which should be working as intended, but isn't:

1.
I have an VBA array *asglWriteBack(1 to 139)*, which is correctly filled with singles.

2.
Also, I have a range of the same dimension, which is a column of an listobject table: *mlstCurrentStratTable.ListColumns(14).DataBodyRange*.

3.
What I want to do is to assign the array to the range to have the range (table column) filled; so I try: *mlstCurrentStratTable.ListColumns(14).DataBodyRange = asglWriteBack*.

P.
The problem is, that the entire column (i.e. all of its 139 cells) is not being mapped to the array content, but only filled with the content of the first array element: When the first array element asglWriteBack(1) has the value 'xyz', then the entire range mlstCurrentStratTable.ListColumns(14).DataBodyRange gets assigned 'xyz'. What I am doing wrong here with the mapping?

ps: I don't want to iterate all the range's cells individually; I'd like to 'flash'-in the array onto that range.



Thank's alot for you suggestions!

 

[Andrew Poulsom]

Try:

mlstCurrentStratTable.ListColumns(14).DataBodyRange = WorksheetFunction.Transpose(asglWriteBack)

 

[Roopher]

Oh yes, this did the job! Thank you very much for the quick reply, too, Andrew Poulsom. Just wondering why I was not trying the transposition by myself...


By the way, how can I insert a code window into my messages as you have done? Would I need some HTML tags?

Cheers!

 

[pgc01]

Hi

Check my signature. You can also use the button # in the post editor.

 

[Roopher]

 Debug.Print "Thanks pgc01 for the tip :)"