Forum Discussion

rodsan724's avatar
rodsan724
Copper Contributor
Aug 31, 2023
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.

Resources