Ok, right now I have a range.find method to try to...well...find some data...but it keeps giving me an error when the data I'm searching for isn't there.

VB Code:
  1. If IsNull(Cells.Find(What:=Worksheets("Open Orders").Cells(i, 1), After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
  2.     xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
  3.     , SearchFormat:=False).Activate) = True Then
  4.            
  5.     Sheets("Open Orders").Cells(i, "N") = 0
  6. Else
  7.     Sheets("Open Orders").Cells(i, "N") = ActiveCell.Offset(0, 34)
  8. End If
Now, I'm assuming I'll have to change that IsNull to something else to be able to catch it, but I'm not sure what I have to change it to, or if that's even the right direction to go in.