Yes, Excel transposes cell ranges within formula's as well (if you don't know
this I don't know why you are an MVP). The question you SHOULD have asked is
"Did you mis-understand the post." I believe I did mis-understand by reading
through your second post.

--
Regards,
Dave


"Gord Dibben" wrote:

Have you actually tested this method?


Gord Dibben MS Excel MVP

On Thu, 31 Aug 2006 11:37:02 -0700, David Billigmeier
wrote:

Copy your range.
Right click where you want to paste
<Paste Special...
Check "Transpose"