The following code is in the WorkSheet_Change function.
Here is the problem. Since I change the value in column 7 (loopRange.Cells(r,7).Value = Target.Value) in the For loop then the Worksheet_Change function gets invoked again.
How do I disable the Worksheet_Change function until the For loop finishes? If I change the 7 to an 8 (place the value one column to the right) then this thing works fine.
Also, how do I determine if useThisDate is a blank cell? I can't figure that out either.
Thanks.
Thomas
Bookmarks