Message box will appear when 1) Total in Col.G is wrong and updates it to correct value.2) the new file name is already exists in the same folder as one folder can't have duplicate file name.I don't understand such error as it runs without error here.Wait for someone else.