[RESOLVED] if else statement

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

Code:

---

     
 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

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

Code:

---

  ' 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

Try this

Code:

---

If Not oRng Is Nothing Then

End If

---

Quote:

---

Originally Posted by koolsid

Try this

Code:

---

If Not oRng Is Nothing Then

End If

---

---

Or rather:

Code:

---

If oRng IsNot Nothing Then

End If

---

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

Quote:

---

Originally Posted by rjhe22

Code:

---

     
 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.

@JM: Yup. :)

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

Quote:

---

Originally Posted by koolsid

@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.

that worked thanks
also will look into the dot stuff thanks