Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23

Thread: formula to generate reordring or resorting from given word

  1. #21
    New Member
    Join Date
    Mar 2019
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    this is macro i use maybe problem with it?
    Code:
    Sub Macro4()
                '
                ' Macro4 Macro
                    ' Macro recorded 18/03/2019 by bob
            '
                                    
        '
        For j = 1 To 4
        For k = 1 To 4
        For l = 1 To 4
        For m = 1 To 4
        Cells(1, 6) = j: Cells(2, 6) = k: Cells(3, 6) = l: Cells(4, 6) = m
        thisperm = Cells(7, 7)
        Sum = Sum + 1
        Cells(Sum, 1) = thisperm
            Next m
                Next l
            Next k
            Next j
                    End Sub

  2. #22
    Board Regular
    Join Date
    Apr 2010
    Posts
    10,985
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    1 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    make mytable equal to I1:J4 for test purposes, and not sure why you define the sheet - I use excel 2000 so maybe your version is different........

  3. #23
    New Member
    Join Date
    Mar 2019
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    in name box i put I1:J4 then enter mytable that how created

    ok is this correct? if its correct way its still generate number
    http://ipic.su/img/img7/fs/14.1553176066.png

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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