View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default transpose - array problem

You may get better responses if you post the range getting the formula and the
formula you're using.

bretp wrote:

I'm trying to use the transpose function. When I hit ctrl-shift-enter after
F2 I get a formula error dialog. Upon closer inspection and testing a period
appears after the transpose function in the cell after the ctrl-shift-enter
combination.

This is Excel 2003 in Windows XP environment. It appears to be machine
specific because I copied the spreadsheet to my laptop which is running Excel
2002 and was able to get the transpose to work. When I move it back to the
original computer it is fine.

Thanks.


--

Dave Peterson