Hi Radiant, Michael
Thanks for your efforts, but no luck unfortunately.
I thought it might be useful for you to see the buildup to the code. Also, I am using MO 2011. The code is massive, but this is everything that appears before the insert column code. Basically this macro is sorting out a mass of data into some semblance of order - Sub MainC() is where the error occurs.
I have attached as a txt file
Thanks again
Alex
Bookmarks