SOLVED

Excel inserting new column takes on attributes of the column before it

Brass Contributor

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.

1 Reply
best response confirmed by rodsan724 (Brass Contributor)
Solution

@rodsan724 

Or use the line that you posted, then delete data validation from the newly inserted column.

1 best response

Accepted Solutions
best response confirmed by rodsan724 (Brass Contributor)
Solution

@rodsan724 

Or use the line that you posted, then delete data validation from the newly inserted column.

View solution in original post