Results 1 to 4 of 4

Thread: Split Range into Multiple Columns VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-07-2012, 03:18 PM #2
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    There seem to be situations where this code does not work correctly... actually, I should say, cannot work correctly. Select a single column of 20 cells and specify you want 8 columns made from it... you will/can only get 7 columns as long as you insist that each column should have the same number of rows in it (with the last column possibly having less). Perhaps the "How many columns do you want?" question should be changed to "How many columns maximum do you want?"...

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://eileenslounge.com/viewtopic.php?p=320960#p320960
    https://eileenslounge.com/viewtopic.php?p=320957#p3209573
    https://eileenslounge.com/viewtopic.php?p=318868#p318868
    https://eileenslounge.com/viewtopic.php?p=318311#p318311
    https://eileenslounge.com/viewtopic.php?p=318302#p318302
    https://eileenslounge.com/viewtopic.php?p=317704#p317704
    https://eileenslounge.com/viewtopic.php?p=317704#p317704
    https://eileenslounge.com/viewtopic.php?p=317857#p317857
    https://eileenslounge.com/viewtopic.php?p=317541#p317541
    https://eileenslounge.com/viewtopic.php?p=317520#p317520
    https://eileenslounge.com/viewtopic.php?p=317510#p317510
    https://eileenslounge.com/viewtopic.php?p=317547#p317547
    https://eileenslounge.com/viewtopic.php?p=317573#p317573
    https://eileenslounge.com/viewtopic.php?p=317574#p317574
    https://eileenslounge.com/viewtopic.php?p=317582#p317582
    https://eileenslounge.com/viewtopic.php?p=317583#p317583
    https://eileenslounge.com/viewtopic.php?p=317605#p317605
    https://eileenslounge.com/viewtopic.php?p=316935#p316935
    https://eileenslounge.com/viewtopic.php?p=317030#p317030
    https://eileenslounge.com/viewtopic.php?p=317030#p317030
    https://eileenslounge.com/viewtopic.php?p=317014#p317014
    https://eileenslounge.com/viewtopic.php?p=316940#p316940
    https://eileenslounge.com/viewtopic.php?p=316927#p316927
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 10-04-2024 at 10:18 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. 10$ For VBA Code Split Data To Multiple Workbook Based On Unique Values In A Column
    By jamilm in forum Hire A Developer
    Replies: 17
    Last Post: 05-22-2013, 11:58 PM
  2. Sumif On Multiple Columns Using Multiple Criteria By Passing A Range Of Values
    By Luke M in forum Excel Help
    Replies: 7
    Last Post: 05-15-2013, 02:56 PM
  3. Split Data in Table To Multiple Rows Based On Delimited Text In Columns
    By nick5_86 in forum Excel Help
    Replies: 4
    Last Post: 05-01-2013, 09:49 PM
  4. Split Row Data In To Multiple Columns Based On Delimiter
    By cjjn in forum Excel Help
    Replies: 2
    Last Post: 03-05-2013, 07:34 AM
  5. Transpose Multiple columns data into multiple rows
    By manoj in forum Excel Help
    Replies: 2
    Last Post: 06-14-2012, 04:10 AM

Tags for this Thread

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
  •  

Forum Rules