Hi champs,
pls help me with a macro to swap any two columns.
for example i need to swap column A to column Z?
Thanks in advance.
Hi champs,
pls help me with a macro to swap any two columns.
for example i need to swap column A to column Z?
Thanks in advance.
Try this:-
Regards Mick![]()
Please Login or Register to view this content.
Hi,
Try this:
In the immediate window use this code to perform the above macro.![]()
Please Login or Register to view this content.
call swapcolumns("A","B")
Change A and B for any two column letters you want to swap.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks