Thread: Find
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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


.