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...