Excel Crashes on using Transpose function

[ajitpalsinghdhillon]

Hi All

I've always been a passive user of this pages which have provided me a
solution to all my excel problems just browsing through these pages.
For the first time it hasn' worked so posting my problem here.

On using the following function excel crashes. Can someone figure out
why:

=TRANSPOSE(INDIRECT(ADDRESS(row($A$1:$B$5),COLUMN($A$1:$B
$5),,,"Sheet1")))

I'm writing the formula on Sheet2. The formula works fine when being
used on Sheet1.

It goes without saying that I will owe a huge debt of gratitude to
anyone who can shed some light on this.

Ajitpal

 

[papou]

Hello Ajitpal
Just tested on my Excel 2003 SP3, your formula works perfectly.
What is the expected reference? In your example, reference is Sheet1!A1.
Did you check with the evaluate option available from the Audit formula tool
bar?

HTH
Cordially
Pascal