Thread: Strange error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Filips Benoit Filips Benoit is offline
external usenet poster
 
Posts: 28
Default Strange error

Dear All,


ActiveSheet.Cells(iloop, 5).Value = "=Sum(F688:F727)*0,05"
This line triggers error 1004 Application defined or object difined error

\/
ActiveSheet.Cells(iloop, 5).Value = "Sum(F688:F727)*0,05"
If i ommit the = before Sum there is no error but the formular is not
correct!!

How do i solve this

Filip