Excel Crashes when using the Transpose Function

A

Ajit

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Crashes on using Transpose Function 0
Excel Crashes on using Transpose function 1
Problem with transpose function 4
Keep original cell formatting when using transpose array formula 1
Transpose large column 3
What wrong is it on using the indirect function? 2
Automatically copying data from sheet1 to sheet2 2
Copy data automatically from sheet1 to sheet2 0

Top