Thread: Run Time Error 1004 - Application-defined or object-defined error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brent Brent is offline
external usenet poster
  
Posts: 109
Default 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 QuoteReply With Quote