Find
 

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

Find
 

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

-----Original Message-----
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


.

still need help
 

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


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

-----Original Message-----
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


.

.

still need help
 

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

-----Original Message-----
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


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

-----Original Message-----
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


.

.

.