Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Crashes on using Transpose Function
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashes when typing "false" in VLookup function | Excel Worksheet Functions | |||
Transpose function | Excel Discussion (Misc queries) | |||
Transpose Function | Excel Worksheet Functions | |||
Help with function that crashes Excel | Excel Programming | |||
How do I use the Transpose Function | Excel Worksheet Functions |