Sorry for the bother again, I've been continuing improving what I made, and was just now trying to make a if then statement work by putting it before this. Such as If Ash.columns("e" )> ash.columns("F) " Then (the following will occur. I'm not even sure if this is possible. But Thanks for even taking the time to read this.
Code:
For Each cell In Ash.Columns("b").Cells.SpecialCells(xlCellTypeConstants) If cell.Value Like "?*@?*.?*" And LCase(cell.Offset(0, 2).Value) = "yes" Then 'Use this to set range of Cells, as in what columns to put in
Comment