Thread: Formula is evaluated as a constant instead of a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jb jb is offline
external usenet poster
  
Posts: 2
Default 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?

Reply With QuoteReply With Quote