Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run time error '91'
the most common suggestion is to check to see what happened:
Sub Testme01() Dim FoundCell As Range with activesheet Set FoundCell = .Cells.Find(what:="what???",...rest of find command) If FoundCell Is Nothing Then 'it wasn't found Else 'it was found End If end with End Sub And this looks kind of scary to me: */07/04 00 If your field really has an asterisk in it, you may want to look for: ~*/07/04 00 ~* means to find the asterisk character. Without that leading tilde, the asterisk will be used as a wildcard. (maybe that's what you want, though.) tina wrote: My problem is I recorded a macro with find in but when i ran it later I get error message "object variable or with block variable not set" the part of macro it errors on is as follows Selection.Find (What:="*/07/04 00", After:=Activecell, LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False).Activate when recording it works fine Any ideas would be much appreciated Thanks Tina -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming |