![]() I have just noticed that by adding the "GOTO" statements in some of my IF-statements, prevents the error from occurring. I know it's not the most intelligently written, but it's what I have so far. ![]() I have posted more of my code section below. One of these subs calls the one I am having trouble with right now, but I do not have the call wrapped in the error handler. I have "On Error Resume Next" in other Sub Procedures I have created. I know that it is not good to rely on worksheet functions too much, but this is more of a general question as to why it's not working consistently all through my code. currently assumes a feeĮdgeName = "F_" & Mid(netName, 3, ("-Deferred", netName) - 3) & "_Deferred" & endOfCode currently assumes a feeĮdgeName = "F_" & Mid(netName, 3, (" Due", netName) - 3) & "_Paid" & endOfCode 'If IsError((" PRINCIPAL ", netName)) ThenĮdgeName = "T_" & ReturnFirstWord(netName) & "_Principal" & endOfCodeĮdgeName = "T_" & ReturnFirstWord(netName) & "_i_Deferred" & endOfCodeĮdgeName = "T_" & ReturnFirstWord(netName) & "_i_Paid" & endOfCode If IsError((" TOTDUEINT ", netName)) Then If IsError(("_*-DEFERRED", netName)) Then NetName = UCase(Trim(Sheet1.Range("netLIBOR").Offset(yG, xR))) ![]() NetName = ReturnLastWord(Sheet1.Range("netLIBOR").Offset(yG, xR))ĮdgeName = (netName, Sheet3.Range("tokenTable"), 2, 0) 'If InStr(1, tempNetName, " DUE FROM ", vbTextCompare) = 0 Then If IsError((" DUE FROM ", tempNetName)) Then ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |