Align Row Content with cell format to Left column & Delete Blank row

[SamT]

My bad

try xlShiftToLeft

Shift right is not an option when deleting cells. It's either shift up or shift left.