Excel VBScript插入列和填充

I'm trying to insert a column to an Excel spreadsheet via a script. I found the code below which should allow me to insert a column, but how would I then go about filling that column with data like I would in the Excel application using the fill>down or fill>series commands?I'm trying to insert a column to an Excel sprea