Thanks for taking the time to help me. I tried your suggestion but i get the message object doesn't support this property or method. I've tried moving the code to after the End With statement but I get the same results.
I've tried changing xlbook to Worksheets, i changed sheets (1), i added xlapp in front of xlbook, I tried xlbook.sheets (1).Insert.Column and about 20 other variations and combinations of commands but nothing seems to work.
does the workbook need to have a name (be saved) before it will work?
Do I need to activate a Library in my Preferences? I'm lost.
I don't know if this matters, but when I hover my mouse over the declaration for xlbook nothing shows, but when i hover over xlapp it shows ="Microsoft Excel". For some reason it seems to get hung up on xlbook?
Do you have any other suggestions I can try?