Hrm I have never used an Excel macro.. are you saying I can record a macro then put the code it generates into VB and vb will do exactly what I did to the excel file when I run it in vb?

Thanks for bearing with me ,
Thai