Thanks Grahm for you help. I have been experimenting with the code you provided and it works. Many thanks for helping me organize my code. I was wondering how I get control of the excel workbook so that i can add a couple of columns in between A and B and B and C, so that i have a column of data empty column, column of data, empty column.

I have tried setting up a sub called insertcolumn, and I tried using getobject and createobject and just about everything inbetween, but I just can't seem to get control over Excel. I hate to ask, but could you give me a hint on what I need to do?