I have a macro (I do not recall where I got this) that Rearranges the order of columns on a sheet which can have hundreds of columns by an array of header names
So if the array of headers isthen my sheet would look like![]()
Please Login or Register to view this content.
front.png
But I often need to place the columns at the END of the sheet
So if the array of headers isthen my sheet would look like![]()
Please Login or Register to view this content.
reverse.png
But I can not figure out how to alter the Sub and/or function to do this
Thank you in advance for your help with this
(I have a macro that does this with pasting and cutting but is extremely slow on sheets with lots of columns)
![]()
Please Login or Register to view this content.
Bookmarks