ISERROR formula in VBA not working for me

C

Cesar Zapata

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 .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Array Help in VBA 3
Macro autofills formula when a cell value is changed 4
#NAME? on correct formula 4
Vlookup in vba - how to use absolute rows not relative 1
Formula R1C1 in VBA - Strange Results (Dynamic) 2
Scrabble Value calculation for Welsh words 0
Writing Array formulas in code 4
Excel How to code in excel vba 2007 using absolute refernce for cells 1

Top