[RESOLVED] if else statement

[rjhe22]

hi
im using thses line of code to pull stuff of an excel sheet

       
 oRng = oWSSheet2.Cells.Find("Class B", , _
Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart, _
Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, False)
        ' MsgBox("Value '" & app oRng.Value & "' found at '" & oRng.Address)
            Me.classb = oRng.Offset(0, 42).Value
            oRng = Nothing

but sometime some spreadsheets wont have the word class b in it but i get an error if it doesnt. i want to put in an if statement so if its null to go to next piece of code.

how can this be done in vb

if i try this
if orng is not null then
Me.classb = oRng.Offset(0, 42).Value
else
....
but that's not quite right

[rjhe22]

when i try this i get an error as my values are in Decimal

   ' MsgBox("Value '" & app oRng.Value & "' found at '" & oRng.Address)
        If Me.classb = String.Empty Then
            Me.classb = 0.0
        Else

            Me.classb = oRng.Offset(0, 42).Value
        End If

anyway around this

[Siddharth Rout]

Try this

If Not oRng Is Nothing Then

End If

[jmcilhinney]

Try this

If Not oRng Is Nothing Then

End If

Or rather:

If oRng IsNot Nothing Then

End If

Functioanlly equivalent but much more natural, which is why IsNot was added to the language.

[Grimfort]

       
 oRng = oWSSheet2.Cells.Find("Class B",

To note, you appear to be using the double-dot notation, which is notorious for stopping the release of the object, meaning that Excel does not close when your code is completed.

[Siddharth Rout]

@JM: Yup.

@Grimfort: There is nothing wrong with the usage of two dot rule. You might want to see this?

[Grimfort]

@Grimfort: There is nothing wrong with the usage of two dot rule. You might want to see this?

I don't think there is enough evidence in that blog to backup that statement. I have tried (there are samples I have posted on this forum) using all kinds of methods including forcing GC and ReleaseComObject, and the clear-up was not successful in all circumstances. I won't go into a debate on it here, but from my own experience in this area, it is something to avoid, or at least understand if you get the issue.

[rjhe22]

that worked thanks
also will look into the dot stuff thanks