I have a piece of code that I written that searches column O for a value of 1 and when found it checks the value in column N [offset(-1,-1)] to see if matches certain criteria. If does not then the range is resized to 6 rows cut and then pasted after the first example of a 6 is found in column...