How many columns are in the table you are working on, the provided code starts looking at column 11 onwards within the table. If your table is smaller for exampe you would need to edit the bit in red below:
    On Error Resume Next        
    For x = 1 To UBound(var) ' rows
        For y = 11 To UBound(var, 2) ' columns
            If var(x, y) = toFind Then
                tblCol = y: GoTo foundit
            End If
        Next y
    Next
    On Error GoTo 0
Other than that it's tricky without a sample file.

The 11 above is the first column to start searching for the value in the table.