Formula is evaluated as a constant instead of a formula
 

ActiveCell.FormulaR1C1 = _
"=LOOKUP(RC[1],'[Account Listing Report by
Cardholder.xls]List'!R2C2:R98C2,'[Account Listing Report by
Cardholder.xls]List'!R2C1:R97C1)"

This formula is not returning results it is only showing up as text.

What can I do to fix this?

Formula is evaluated as a constant instead of a formula
 

with activecell
.numberformat = "General"
.formular1c1 = ....
end with

jb wrote:

ActiveCell.FormulaR1C1 = _
"=LOOKUP(RC[1],'[Account Listing Report by
Cardholder.xls]List'!R2C2:R98C2,'[Account Listing Report by
Cardholder.xls]List'!R2C1:R97C1)"

This formula is not returning results it is only showing up as text.

What can I do to fix this?

--

Dave Peterson

Formula is evaluated as a constant instead of a formula
 

Thank you. It's fixed