Hello,

I have formula #1 included in a report generating macro that I am
currently attempting to debug. Formula #1 is exactly what I have
entered in the VBE. The problem is, when I run the macro, it enters
formula #2 in the spreadsheet, which doesn’t make sense to me. It
changes my lookup array, from my variable “Cusip” to “CorpA”, which is
the sheet where formula is being entered. What am I doing wrong
here?

1) Corp.Range("BA4").Resize(DataRow, 1).FormulaR1C1 =
"=VLOOKUP(RC[-48]," & Cusip.Address(external:=True,
ReferenceStyle:=xlR1C1) & ",2,FALSE)"

2)=VLOOKUP(E4,CorpA!$A$1:$D$2027,2,FALSE)