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 . |
All times are GMT +1. The time now is 03:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com