Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ISERROR formula in VBA not working for me
Hi,
I'm recording a formula and then I want to add the thisworkbook.name part instead of mvtquery.xls. I tried adding something like this but is not working the recorded part " & thisworkbook.name & " the other recorded part. I think I may be missing a " somewhere but I cant find it. this is driving me nuts. ActiveCell.FormulaR1C1 = _ "=ISERROR((VLOOKUP(VALUE(LEFT(R[1]C,(SEARCH(""("",R[1]C)-2))),[MvtQuery.xls] Sheet3!R70C1:R100C2,2) &"" ""&RIGHT(R[1]C,LEN(R[1]C)-SEARCH("" "",R[1]C))))"""" VLOOKUP(VALUE(LEFT(R[1]C,(SEARCH(""("",R[1]C)-2))),[MvtQuery.xls]Sheet3!R70C 1:R100C2,2) &"" "" " Thanks for your help . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding =if(iserror to formula | Excel Discussion (Misc queries) | |||
Replacing ISERROR Formula | Excel Worksheet Functions | |||
Formula Help - Lookup, if, iserror?? | Excel Discussion (Misc queries) | |||
Using iserror in formula | Excel Discussion (Misc queries) | |||
Iserror not working as expected | Excel Worksheet Functions |