Forum Discussion
Solved
Excel inserting new column takes on attributes of the column before it
I have a named table in a worksheet. The left most column contains a DataValidation List. When I insert a new column to the left of it with the following, it takes on the same DataValidation List which I didn't expect.
Selection.ListObject.ListColumns.Add Position:=1
Is there a way to add default column without any properties from the previous first column? I guess I could copy a normal column and insert it that way perhaps.
Or use the line that you posted, then delete data validation from the newly inserted column.
1 Reply
Or use the line that you posted, then delete data validation from the newly inserted column.