Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » Transpose (RSS)

Browse Site by Tags

Showing related tags and posts accross the entire site.

  • Any way to increase maximum columns?

    I use Excel 2000 under Windows XP. The maximum number of columns seems to be 230 (A-IV). Is there any way to increase the number of columns? I am using the transpose option when pasting ~700 rows, and it is a real pain to have to do it in 4 pieces, and of course, greatly increases the likelihood of making...
    Posted to General (Forum) by Taxon on Mon, May 19 2008

  • Re: Macro - Column to Row

    Jim I doubt this is the full extent of your issue, but using you example... Sub TransposeRng() Range( "A1:E1" ).Value = Range( "A1:A5" ).Value Range( "A2:A5" ).Clear End Sub Post back when you want this done for many columns
    Posted to General (Forum) by Nick Hodge on Fri, Feb 22 2008
Page 1 of 1 (2 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.