It appears (to me, anyway) that the transpose function only transposes values, not formulas.
>>Would you please care to show (in a workbook) how you get that to work if you have formulas in original range?<<
I'm gettin' pretty old and forgetful (= "senile") and don't want to post anything I do that I'm not absolutely sure about.
And I'm not absolutely sure about anything anymore...