It's probably faster and easier to just select the range of the matrix,
whatever size and the paste special:transpose, like this:

Range("A1:F99").Copy
Range("H1").PasteSpecial Paste:=xlAll, Operation:=xlNone,
SkipBlanks:=False, Transpose:=True

Mark

---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!