| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complie error: Expected: end of statement
Hi, I've got a macro code as below: Range("A1").FormulaArray = _ "=if(B1="Loan",D1,0)" And it causes a compile error. How should I fix it if I want to keep the text Loan in my formula. Thanks so much |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Complie error: Expected: end of statement
Hi, Firstly it's not an array formula and so no need for FormulaArray and second double up on the quotes to solve your problem Range("A1").Formula = "=if(B1=""Loan"",D1,0)" Mike "diepvic" wrote: Hi, I've got a macro code as below: Range("A1").FormulaArray = _ "=if(B1="Loan",D1,0)" And it causes a compile error. How should I fix it if I want to keep the text Loan in my formula. Thanks so much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Expected end of statement ERROR | Excel Programming | |||
| Expected end of statement error | Excel Programming | |||
| Overcome "expected end of statement error" | Excel Programming | |||
| Micrsoft Visual Basic Compile error: Expected: end of statement | Excel Discussion (Misc queries) | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Hybrid Mode
