That worked. Thanks so much. "Dave Peterson" wrote: > I bet the cells that contain "redi avg" contain more than those > characters--maybe extra spaces??? > > If that's true, maybe you could eliminate those spaces with: > > If trim(.Cells(i, 7).value) = "adj" _ > Or trim(.Cells(i, 7).value) = "redi avg" ...
