SOLVED! - [Excel - Office 2007] EXACT intrinsic function is causing "Sub or Function

[dynamo2000]

Hi, I am trying to write a simple macro (subroutine) in VB for Excel, Office 2007. I keep getting Sub or Function not defined error. I presume it is not a syntax error on my part (please let me know if it is something this simple). Is there some library I am supposed to include from the References dialog box? In any case here is the code:

Sub SubTable()
rri = 251
For rd = 24 To 102 'Row for Domaiin category
Windows("Initial Category List - Final Version.xlsx").Activate
od = Cells(rd, 4).Value 'old category name
nw = Cells(rd, 8).Value 'new category name
Windows("Combined product ListUpdate1Macro.xlsm").Activate
For rr = rri To 1665 'Row in the Range
If EXACT(od, Cells(rr, 8).Value) = TRUE Then '<-- This is the row causing the problem
Let Cells(rr, 8).Value = nw
Else
rri = rr
GoTo nrd
End If
nrd: Next rd
MsgBox "At the end rri should = 1665, actual value at end =" & rri
Return
End Sub

[pike]

hi dynomo
try..

 Set wb1 = Workbooks("Initial Category List - Final Version.xlsx")
    Set wb2 = Workbooks("Combined product ListUpdate1Macro.xlsm")
    Rri = 251
    With wb1.Sheet1
        For rd = 24 To 102    'Row for Domaiin category
            od = .Cells(rd, 4).Value    'old category name
            nw = .Cells(rd, 8).Value    'new category name
            With wb2.Sheet1
                For rr = Rri To 1665    'Row in the Range
                    If od = .Cells(rr, 8).Value Then   '<-- This is the row causing the problem
                        .Cells(rr, 8).Value = nw
                    Else
                        Rri = rr

                    End If
                Next rr
            End With
        Next rd
    End With
    MsgBox "At the end rri should = 1665, actual value at end =" & Rri

[westconn1]

to clarify
EXCACT is a worksheet function
generally worksheet functions are specified like

if worksheetfunction.exact(str1,str2) then

but in the case of exact (and some of the other worksheet functions), it is not available to VBA, as VBA has other methods to achieve the same result

[dynamo2000]

Thanks for your help!