| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
| backwards find function to find character in a string of text | Excel Programming | |||
Hybrid Mode
