Strange error

[Filips Benoit]

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

 

[Don Guillett]

try

ActiveSheet.Cells(iloop, 5).Value = "=Sum(F688:F727)*0,05"

ActiveSheet.Cells(iloop, 5)= application.Sum(range("F688:F727"))*1
or
ActiveSheet.Cells(iloop, 5).Value = application.Sum(range("F688:F727"))*1

 

[kkknie]

I get the same error. Could it be that your regional settings are no
correct? I notices that you use 0,05 which will not work on my PC. I
I change your code to use 0.05, it works for me.

Go to Tools menu and select options. Check the International tab an
make sure decimal separator is set to comma (assuming that's what yo
use where you live).

 

[Tom Ogilvy]

ActiveSheet.Cells(iloop, 5).Formula = "=Sum(F688:F727)*0.05"

Change the comma to a period.

Value would still work, but it is clearer to use Formula

 

[Tom Ogilvy]

There is no need to change the decimal separator setting. Formula (or in
this case Value) expects US English formatting in VBA.

 

[kkknie]

Wow. That's not very "internationally correct".

 

[Tom Ogilvy]

formulaLocal

will work with a localized formula. Where's the problem?

 

[Filips Benoit]

Changing the comma to a period did the job.

Thanks