Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 91 on Find second time through a loop
I have the following code in a For loop which goes through every file in a
folder: On Error Goto NoData Columns("A:A").Select Cells.Find(What:="06/30/2003").Activate I'm having trouble getting the On Error to work. The first file where the find fails works fine -- it goes to the NoData statement and continues on. With the second file, I get an error 91: Object variable or With block variable not set. How do I get the On Error statement to take effect with every file, not just the first? -- Regards, Fred |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run time error 1004 in loop | Excel Discussion (Misc queries) | |||
run time error 1004 in loop | Excel Discussion (Misc queries) | |||
Loops to find blanks then loop to find populated | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Run-time error '91' on Cells.Find() | Excel Programming |