Can someone please explain how this rearrange column macro works?

[antman2988]

I have found this piece of code from somewhere else, and I modified it a bit to meet my needs, but I'm not entirely sure how it works. The reason I would like to know how it works is because I would like to modify it further, but I am newer to VBA and do not understand how the Resize, Index, and Evaluate functions work together in this macro.

Sub RearrangeColumns()
  Dim newColumnOrder As Variant
  newColumnOrder = Array(1, 2, 3, 4, 41, 42, 43, 44, 5, 6, 49, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 45, 46, 47, 48, 50, 51, 52)
  Range("A1").Resize(Cells.Find("*", , xlFormulas, , xlRows, xlPrevious).Row, UBound(newColumnOrder) + 1) = Application.Index(Cells, Evaluate("ROW(1:" & Cells.Find("*", , xlFormulas, , xlRows, xlPrevious).Row & ")"), newColumnOrder)
End Sub

Any help is appreciated! Thanks!

 

[RoryA]

As you should know by now:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Explanation on How Macro to Rearrange Columns Works Excel VBA
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.