Is there any way to use a macro to repostion columns in a worksheet.
I've attached a simple example, I basically want to be able to run a macro that will repostion (in this sample) columns B, C and G, so they appear between coulmns E and F? There would need to be an option to reset the columns back to their original position as well. Whilst the colour is simply to highlight the relevant columns, the moved columns would need to maintain any formatting, header colours etc...
Many thanks
Bookmarks