I'm getting this error with the line
My understanding is that the error means that something I'm referring to can't be found like a sheet or a variable or something?
What I'm trying to do is check if a cell in a worksheet contains "_START" and if not then do some stuff.
I've checked and VBA is recognising Sht so I can't think why its upset?
Code:
If Sht.UsedRange.Find(What:="_START", After:=Sht.Range("A1"), LookIn:=xlValue, LookAt:=xlPart) Is Nothing ThenWhat I'm trying to do is check if a cell in a worksheet contains "_START" and if not then do some stuff.
I've checked and VBA is recognising Sht so I can't think why its upset?
