Thank you benishiryo, I'll try it now. Regarding the whole column, yes, my file does seem to slow down excel to the point it sometimes crashes, I thought I got a virus from somewhere.

Thanks! Will tell you what happens.