Posted to microsoft.public.excel.programming

Stephen

external usenet poster

Posts: 26

IF formula syntax problem

Hi folks,

I'm trying to get my code to insert an IF formula into a cell...

Range("D2").Select
ActiveCell.Formula = "=IF(C2='Y',1,0)"

but I keep getting an object-defined error. I've tried variations of quotes
and parens. but the best I am able to come up with is having it populate the
formula as a string. What am I missing?

Thanks.

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
Syntax problem	unknowndevice[_4_]	Excel Programming	4	August 26th 05 10:57 PM
Syntax problem	Alex H	Excel Worksheet Functions	1	July 2nd 05 08:23 AM
Syntax Problem with formula code	Todd Huttenstine	Excel Programming	7	May 10th 04 05:35 PM
Another Syntax Problem	Sharlene England	Excel Programming	2	December 2nd 03 10:04 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us