+ Reply to Thread
Results 1 to 6 of 6

Macro editing

  1. #1
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Office365
    Posts
    305

    Red face Macro editing

    Hello Experts,

    I am novice in Macro, guru kvsrinivasamurthy has solved brilliantly for similar set of numbers.
    Now I am using new set of different but less numbers. I have tried unsuccessfully replacing numbers suggested by kvsrinivasamurthy. ( you may may see details under my name Karnik , solved )

    Use only 2,4,6,8, numbers to get single digit, two digit, three digit , four digit possibilities
    Goal seeking Results:-
    single digit output :-, 2,4,6,8,
    Double digit out put :- 24,26,28,46,48,68,22,44,66,88,
    Few three digit examples: 246,248,468,,222,444,666,888 and so on....
    Please see attached Excel 2007 file, currently I do manually that is prone for may omissions,
    Thanks in advance
    Karnik
    Attached Files Attached Files

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Macro editing

    Should both
    24
    and
    42 be listed?

    Try this:

    Please Login or Register  to view this content.
    Last edited by Jakobshavn; 01-07-2013 at 07:47 PM.
    Gary's Student

  3. #3
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    818

    Re: Macro editing

    Hello Jacobshavn,

    This is a faster methode to write.....
    Please Login or Register  to view this content.
    .....than.
    Please Login or Register  to view this content.
    Here is a variant that is even fast.
    Please Login or Register  to view this content.
    Kind regards, Harry.

  4. #4
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Office365
    Posts
    305

    Re: Macro editing

    Hello HSV and Jacobshavn
    Thanks for looking in to my issue, both Macros works, but basic criteria is missing, which is in a row, second digit cannot be smaller than first, e.g. 2,4 is fine but not 4,2 for three digit 2,4,6, if fine but not 4,2,6, or 4,6,2
    So two digit possible outputs are only 24,26,28,46,48,68,22,44,66,88 and not 42,64,84..... etc.
    I am novice to Macros, I am unable to edit/modify !
    Thanks
    Karnik

  5. #5
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    818

    Re: Macro editing

    Hello Karnik,

    New attempt.
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Office365
    Posts
    305

    Re: Macro editing

    Hi HSV,
    Thanks, it works perfectly, thanks for the solution,
    Cheers,
    Karnik

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1