I use the below code in a macro that I run every day,
been running it for about 2 months now. Its always worked
fine up until last week it started returning a "variable
not set error". I'm baffled I have tried every thing I
could think of including recording it again but... shrugs

Any ideas?


Cells.Find(What:="Current Unapplied Payment Balance:", _
After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart,_
SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate