Formula in VBA

[JamieDuncan]

Can anyone see whats wrong with this?
Everytime I run my code I get

Application-defined or Object-defined error

strformula = "=IF(SUM(A" & lngTargetSheetRow & ")>0,(LOOKUP(A" & lngTargetSheetRow & ",'" & m_SOURCE_SHEET_NAME & "'!B3:B24,'" & m_SOURCE_SHEET_NAME & "'!C3:C24)),"")"

                Sheets(m_TARGET_SHEET_NAME).Cells(lngTargetSheetRow, "B").Formula = strformula

Any ideas?

 

[Andrew Poulsom]

You need to double up the quotes for your null string:

strformula = "=IF(SUM(A" & lngTargetSheetRow & ")>0,(LOOKUP(A" & lngTargetSheetRow & ",'" & m_SOURCE_SHEET_NAME & "'!B3:B24,'" & m_SOURCE_SHEET_NAME & "'!C3:C24)),"""")"

 

[JamieDuncan]

Thanks Andrew, didnt notice that.