OK, I'll bite. It's late at night and I'm waiting for the bridge results to come out, so I'll try to turn my telepathy mode on. Excel has two ways of inserting rows and columns, even from the keyboard. If you try Insert | Cells (or its equivalent in 2007 or later), you will get the Excel menu that shows what I mean. The two modes are Entire Row/Column and what I call "Bill Gates Knows Best" mode. It sounds to me as if you want entire columns but are using BGKB. Your code should look something like $shtList->Range('zEndList')->EntireColumn->Insert;. This I have taken from another of my nodes, Re^3: Win32::Ole excel external data range, where I show the inserting of rows among other things.

Roboticus is right, though. You would get much better help if you showed the minimum code necessary to demonstrate the problem.

Regards,

John Davies