+ Reply to Thread
Results 1 to 21 of 21

VB code amendment help.

  1. 04-15-2012, 09:38 AM #1
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    VB code amendment help.

    Hi,
    I’ve got this Vb code By “JINDON” and it gives result in 3 columns,what line of the code need to be changed so it give me result in 4 or more columns?
    Please Login or Register  to view this content.

    Thank you and much appreciate any help in advance.
    Regards
    Sem.
    Reply With QuoteRegister To Reply
  2. 04-15-2012, 10:54 AM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VB code amendment help.

    Maybe if we knew what problem the code solves ...
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 04-15-2012, 12:24 PM #3
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Hi SHG,
    thanks for your time see attachment for vb code example.
    I'd like to use it for "combin(15,3)=455 combination ,it need 5 columns across.

    Regards
    Sem
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-16-2012, 05:00 AM #4
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Any suggestion please?
    Thanks
    Reply With QuoteRegister To Reply
  5. 04-16-2012, 12:14 PM #5
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Bump.............
    Reply With QuoteRegister To Reply
  6. 04-17-2012, 07:06 AM #6
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    I would very much appreciate any help,please.
    Thanks
    Reply With QuoteRegister To Reply
  7. 04-17-2012, 06:12 PM #7
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Bump...........
    Reply With QuoteRegister To Reply
  8. 04-18-2012, 06:39 PM #8
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Sorry for Bumping.......
    Reply With QuoteRegister To Reply
  9. 04-18-2012, 08:14 PM #9
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VB code amendment help.

    I can't tell what the code is supposed to do from your example.
    Reply With QuoteRegister To Reply
  10. 04-19-2012, 06:14 AM #10
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Good Morning,
    SHG,what this code does,using the list in column "A" and create unique list in 3 columns and each row include numbers "1 to 12".
    The list in column "A" shortened version of "combin(12,4)=495".I hope, i explained my problem...
    Thanks for your time.
    Sem
    Reply With QuoteRegister To Reply
  11. 04-19-2012, 06:16 PM #11
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Bump...........
    Reply With QuoteRegister To Reply
  12. 04-19-2012, 07:46 PM #12
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Any ideas please...?
    Reply With QuoteRegister To Reply
  13. 04-19-2012, 08:37 PM #13
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VB code amendment help.

    There's a worbook that does this with formulas at http://www.box.com/shared/nqljsd3nlu

    Delete column H, change C2 to 12, and copy the formulas down to 495 rows.
    Reply With QuoteRegister To Reply
  14. 04-19-2012, 10:59 PM #14
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,592

    Re: VB code amendment help.

    This came from

    http://www.ozgrid.com/forum/showthread.php?t=164263
    Reply With QuoteRegister To Reply
  15. 04-21-2012, 09:02 PM #15
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Many many thanks for your help SHG,
    but that is not what i'm looking for, i already have the combinations.
    That code creating Unique rows from "combin(12,4)=495"list in 3 columns,what i need is modify that code to give
    unique rows in 5 columns from "combin(15,3)=455".
    Anyway much appreciate your effort and very sorry for the hassle.
    It looks like there is no solution..???
    Regards
    Sem
    Reply With QuoteRegister To Reply
  16. 04-22-2012, 08:16 AM #16
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    I would not mind,if anyone can give me a hint or link to "google",to search.
    That would be appreciated.
    Thank you
    sem
    Reply With QuoteRegister To Reply
  17. 04-23-2012, 11:54 AM #17
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Bump.......
    Reply With QuoteRegister To Reply
  18. 04-23-2012, 02:14 PM #18
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Bump.........
    Reply With QuoteRegister To Reply
  19. 04-24-2012, 01:21 PM #19
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Very very sorry for bumping...?
    Reply With QuoteRegister To Reply
  20. 04-25-2012, 10:45 AM #20
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    Bump........
    Reply With QuoteRegister To Reply
  21. 04-26-2012, 07:23 AM #21
    sem
    sem is offline
    Forum Contributor
    Join Date
    01-21-2011
    Location
    London,UK
    MS-Off Ver
    Excel 2007
    Posts
    241

    Re: VB code amendment help.

    bump..............
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1