Not sure what you mean by this David.

"Excel transposes cell ranges within formulas" and how it applies to the
subject.

If I have a column of formulas say in column C like =A1+B1 down to =A20+B20

If I paste specialtranspose to D1 I get #REF! in D1 and across.

Maybe I misunderstand your post?

BTW........I didn't get to be an MVP because I was bright, just doggedly
persistent.


Gord


On Thu, 31 Aug 2006 12:47:01 -0700, David Billigmeier
wrote:

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.

Gord Dibben MS Excel MVP