I use this method:

    Public Shared Function GetXLRange(ByVal pSheet As Excel.Worksheet, ByVal pCell1 As String, ByVal pCell2 As String) As Excel.Range
        Try
            Dim rng As Excel.Range
            rng = CType(pSheet.Range(pCell1, pCell2), Excel.Range)
            Return rng

        Catch ex As Exception
            App.ErrorManager.ManageError(ex, False)
            Return Nothing
        End Try
    End Function

>I've been busting my brains on this one. I need to read a particual range in an excel file (ie. B7:G35). The excel file is formatted as a form similar to that of a PO form with a header details and footer. I seem to be having problem reading the details section if I pull the whole file. This is why I would like to pull just the details section.