Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SPOT THE MISTAKE!....
CAN ANYONE SEE WHERE THE ERROR IS WITH THE FOLLOWING CODE. I REGULARLY
HAVE PROBLEMS WITH THE FIND METHOD. MAYBE I'M MISSING AN ARGUMENT OUT, AS IT ALWAYS THROWS THE ERROR "OBJECT REQUIRED" EVEN WHEN THE SERCHSTRING IS IN THE AREA BEING SEARCHED MAYBE THE PROBLEM IS THAT THE SEARCH STRINGS AND SEARCHAREA ARE ON DIFFERENT WORKSHEETS? ANY HELP GREATLY APPRECIATED, JASON. Dim myFoundAddress As String For i = 2 To x On Error Resume Next myFoundAddress = Sheets("Static").Range("MG_Tournaments").Find _ (What:=Sheets("Input").Cells(i, 7), LookIn:=xlValues, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=True, _ SearchFormat:=False).Address If myFoundAddress < "" Then Cells(i, 8) = "True" Else Cells(i, 8) = "False" End If Next On Error GoTo 0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spot the mistake in formula | Excel Discussion (Misc queries) | |||
X marks the spot | Excel Discussion (Misc queries) | |||
Hosur an IT hot spot? | Excel Worksheet Functions | |||
X marks the spot | Excel Programming | |||
I want a name in one spot and it's code in another | Excel Discussion (Misc queries) |