Why not simply delete a column at left before your datarange? When you move all data to left a cell, all previous entries in this column are overwritten anyway!