application not defined error 1004 on inserting formula

[jordanburch]

Hey all,

I have the following


Range("ax2:ax7000").SpecialCells(xlCellTypeVisible).Formula = "=+IF(ISNUMBER(MATCH(RC[-3],'CO SAR'!C[-15],0)),MATCH(''" & ThisWorkbook.Worksheets("Variables").Range("A7").Value & " " & ThisWorkbook.Worksheets("Variables").Range("A3").Value & " IDARRS''!RC[-3],'CO SAR'!C[-15],0),MATCH(''" & ThisWorkbook.Worksheets("Variables").Range("A7").Value & " " & ThisWorkbook.Worksheets("Variables").Range("A3").Value & " IDARRS''!RC[-1],'CO SAR'!C[-13],0))"


it worked before it seemed and all the sudden is giving me the error. Any ideas?

 

[johnnyL]

For starters if that is meant to be one line of code, you need underscores at the end of the first two lines:

Range("ax2:ax7000").SpecialCells(xlCellTypeVisible).Formula = "=+IF(ISNUMBER(MATCH(RC[-3],'CO SAR'!C[-15],0)),MATCH(''" & ThisWorkbook.Worksheets("Variables").Range("A7").Value & " " & _ 
ThisWorkbook.Worksheets("Variables").Range("A3").Value & " IDARRS''!RC[-3],'CO SAR'!C[-15],0),MATCH(''" & ThisWorkbook.Worksheets("Variables").Range("A7").Value & _
" " &  ThisWorkbook.Worksheets("Variables").Range("A3").Value & " IDARRS''!RC[-1],'CO SAR'!C[-13],0))"