Thread: Formula is evaluated as a constant instead of a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote