Results 1 to 12 of 12

Transpose in chunks with vba

Threaded View

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Transpose in chunks with vba

    I have 135,000 cells that need to be transposed which is too large to use the paste special transpose or the transpose array. The range does fit within excels row and column limits but excel just can't handle that many cells at once. Is there vba that would allow me to take the entire selection and transpose itin pieces? Or is there another way to approach this?
    Edit: I should add that I can transpose a row or column at a time but I would need to do that 8000 times.
    Last edited by JPfowl; 08-14-2013 at 11:50 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Concatenate a column of texts into chunks of 10 with VBA
    By annabellesays in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2013, 10:11 PM
  2. Chunks of Macro being skipped when running
    By BehrBrew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2012, 01:01 PM
  3. pasting together chunks of data sequentially
    By m121212 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2010, 03:11 PM
  4. copying chunks of data together
    By m121212 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-14-2010, 12:19 PM
  5. Getting chunks of 200 items for stock query
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1