I want to cut a column and put it at an other place in the same worksheet.
Recording the macro gave me the following code which works perfect:
but after reading on the internet I find at multiple sites the advice to use this code
because it would be faster and uses less memory. And because I need to cut multiple columns I would like to optimize my code.
The only problem is that this one line put's the the column at B instead of inserting and shifting the other columns. In other words: I loose the data which was original in column B.
Any help would be appreciated.
Bookmarks