I'm trying to build a macro that allows me to add a column, copy data from a static area of my sheet and paste it into the new cells. My problem is 2 things: I don't know enough about Excel, and the fact that the range needed for the next run of this macro has changed since cells have been added and the coordinates have changed.
Any help is appreciated.![]()
Columns("I:I").Select Selection.Insert Shift:=xlToRight Range("C6").Select Selection.Copy Range("I6").Select ActiveSheet.Paste
Bookmarks