I am copying and pasting a combo box. When I do so the LinkedCell stays constant. Is there a way to copy it and have the combobox linkcell automatically link to the cell I am pasting it into?

keep in mind I am not vary macro savy.