# Thread: formula to generate reordring or resorting from given word Thanks:  8 Post #5244301 (1)Post #5244876 (1)Post #5244519 (1)Post #5245194 (1)Post #5244630 (1) Likes:  6 Post #5245194 (1)Post #5244301 (1)Post #5246231 (1)Post #5244679 (1)Post #5246521 (1)

1. ## 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. ## 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. ## 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

## User Tag List

#### Posting Permissions

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