JamieDuncan
Board Regular
- Joined
- Aug 23, 2006
- Messages
- 132
Can anyone see whats wrong with this?
Everytime I run my code I get
Application-defined or Object-defined error
Any ideas?
Everytime I run my code I get
Application-defined or Object-defined error
Code:
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?