| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula is evaluated as a constant instead of a formula
Thank you. It's fixed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell currently being evaluated contains a constant | Excel Discussion (Misc queries) | |||
| The cell currently being evaluated contains a constant | Excel Discussion (Misc queries) | |||
| CONCATENATE text to create a formula to be evaluated | Excel Worksheet Functions | |||
| the cell currently being evaluated contains a constant | Excel Worksheet Functions | |||
| Conditional formatting formula is evaluated repeatedly | Excel Programming | |||
Linear Mode
