Posted to microsoft.public.excel.programming

diepvic

external usenet poster

Posts: 31

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Expected end of statement ERROR	Paul Lambson	Excel Programming	3	November 18th 08 09:58 PM
Expected end of statement error	Patrick C. Simonds	Excel Programming	1	August 14th 08 08:28 PM
Overcome "expected end of statement error"	burl_rfc	Excel Programming	2	February 20th 07 03:49 PM
Micrsoft Visual Basic Compile error: Expected: end of statement	IJ	Excel Discussion (Misc queries)	5	October 23rd 06 12:08 AM
Formula expected end of statement error, typing formula into cell as part of VBA macro	[email protected]	Excel Programming	1	July 20th 06 07:58 PM

All times are GMT +1. The time now is 08:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us