VBA - Help on Object Variable or With block variable not set

[szita2000]

Hi guys. I can't make this error to go away.
Basically it is part of a loop where first we find a separate table in the bottom of a crystal style report, then we look in the shortened range (ErrorMachinerng)
I get an Object Variable or With block variable not set error on the
NumberOfStops = ErrorMachinerng.Find(What:=MachineToLookfor).Offset(0, 20).Value row

The NumberOfStops is declared as Long, and the data I am trying to get from the table is a Number which I confirmed with a formula.

Let me know if needed I can post the whole code.

TomisRow = searchrange.Find(What:="Tomi Error Evaluation").Row + 5    Debug.Print "Tomisrow = " & TomisRow
Set smallsearchrange = Range("A" & TomisRow & ":A1000")
FindTotalRowBeneathTomi = smallsearchrange.Find(What:="Total").Row - 2
    Debug.Print "Total row on the bottom = " & FindTotalRowBeneathTomi
Set ErrorMachinerng = Range("B" & TomisRow + 5 & ":B" & FindTotalRowBeneathTomi)


NumberOfStops = ErrorMachinerng.Find(What:=MachineToLookfor).Offset(0, 20).Value
    Debug.Print "Number of stops are: " & NumberOfStops


foundmachineToPaste.Offset(5, (CorrectColumn.Column) - 1).Value = NumberOfStops


Next i

 

[Fluff]

One possibility is that it can't find "MachineToLookfor" in column B

 

[szita2000]

Hi Fluff.
That was it!
I checked the address of the searched range, and I managed to screw it up by 5 row (you can see it in the posed code's first row).
Thanks! Thanks! Thanks!

 

[Fluff]

You're welcome & thanks for the feedback