Posted to microsoft.public.excel.programming

Brent

external usenet poster

Posts: 109

Run Time Error 1004 - Application-defined or object-defined error

Can someone tell me why this formula gives me a run time eror?
Range("E2").Formula = "=IF( AND( NOT(G2),
NOT(ISBLANK(B2)),NOT(ISBLANK(I2))),TODAY()-I2,"" )"

or why this also gives the same error?
Range("E2").Formula = "=IF(G2,I2,"")"

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
Run-time Error 1004: Application-defined or Object-defined Error	Adrian	Excel Programming	6	August 23rd 05 06:28 AM
run-time error '1004': Application-defined or object-deifined error	[email protected]	Excel Programming	5	August 10th 05 09:39 PM
Macro Run-time Error 1004 Application Defined or Object Defined Error	Anddmx	Excel Programming	6	June 9th 04 03:40 PM
"Run Time Error 1004 Application Defined or Object Defined Error."	BJC	Excel Programming	4	October 26th 03 03:09 AM

All times are GMT +1. The time now is 09:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us