View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Short Chris Short is offline
external usenet poster
 
Posts: 7
Default worksheetfunction.transpose - nx1 to n element?

worksheetfunction.transpose has the nice property that passing an n-element
row array returns an n x 1 array (ie it now has two dimensions).

However, I've just stumbled over passing an n x 1 array resulting in single
dimension n element array being returned, rather than a 1 x n array.

This of course is symmetric to the first case, but not what was expected.

I've looked but haven't found any mention of this or a known workaround.

With Excel 2003, I'm looking to confirm this behavior.

thanks,
Christopher