2013年1月22日 - Just replace your Until condition to the following string: Loop Until IsEmpty(ActiveCell.Offset(1, -2)). That will check the right cell for being empty.
stackoverflow.com