I am automating Excel from a VB application.

I attempted to insert a column way down in my code (after populating the
sheet with many columns from data from many files (maybe 32, maybe 48, or 64
columns of ASCII Data).

My code bombed when I attempted the insert of a new column saying it can't
shift cells off the edge of the worksheet. After I failed at that: I
attempted to delete all empty columns to the right of my used area, and my
code also bombs, don't remember that error message right now.

can someone tell me what I need to do in order to either insert new columns,
so that any data will shift off the edge of the sheet, or how I can get my
empty columns deleted. ( I don't need code to find last used column, I
already have that)

Thanks BillReese