Find

[Steve]

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

 

[Frank Kabel]

Hi
after adding a space beore the continuation character '_'
in the second line this works for me

 

[steve]

ya i took out the space so it would look good in the post

it works for me in the workbook that i recoreded it in
it dose not work in the workbook where i paste it though

 

[Frank Kabel]

Hi
could you please post the complete macro. Probably a
wrong/hardcoded workbook/worksheet reference