how do a assign values to a different shaped array?

[madwab]

Suppose I have x cells in a row, named srce, and another x cells in a row, named targ. I can use...

dim myvar
myvar=srce
targ=myvar

...to transfer values from source to target without using copy.

Now suppose I have srce as defined above, but targ is x cells in a column rather than in a row. The above code places the first value in srce into each cell in targ. What code is equivalent to the above code, so that each vaue in srce ends up in targ?


Thanks
===========

Tip of the day: see http://msdn.microsoft.com/vstudio/express/support/faq/default.aspx#pricing for FREE copies of Visual Studio Express 2005 products.

 

[GlennUK]

Dim myvar
myvar = [srce]
[targ] = Application.WorksheetFunction.Transpose(myvar)

 

[madwab]

kool - thanks!

Does exactly what it says on the bottle!

 

[GlennUK]

It sure does!