excel vba，将新列插入其旁边的列的长度，并在列c中键入Ck DUP并填充列B

I have tried to insert an new column and then insert a value ck dup and use fill down to fill in the column.The number of rows should be equal to the number of rows in Previous column.I have tried to insert an new column and then i