Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have the following code snippet that I'm using to find whether one digit is part of another large number using something like: If IsNumeric(WorksheetFunction.Find(Third, y)) Then Result = TRUE Else Result = FALSE End If where y is the large number and 'Third' represents the a particular digit. If the expression in the IF statement does contain the said digit, the result of the statement is that Result variable is assigned the value TRUE. However, if the digit is not contained, then rather than hitting the ELSE bit of the above statement, the code just unexpectedly terminates. Any suggestions? Thx, Schiz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problems with WorksheetFunction.Index and WorksheetFunction.Match | Excel Programming | |||
Find WorksheetFunction - finding text within text | Excel Programming | |||
Problem using "Find" WorksheetFunction in Excel VBA | Excel Programming | |||
Max WorksheetFunction | Excel Programming | |||
WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions? | Excel Programming |