How to fix error 1004 in sum range of cell?

Asked May 07 '21 at 18:57

Active May 07 '21 at 19:27

Viewed 15 times

I have problem with this code:`

Worksheets("IO").Cells(i + 13, 2).Formula = _
        "=sum(" & Worksheets("IO").Range(Cells(i + 1, 6), Cells(i + 1, 5 + numjob)).Address & ")"

and other line code that use with sum of range of cell. Sometimes the code is working, but most of the time is not. What i need to fix? I get error 1004 of applications defined or object defined.

edited May 07 '21 at 19:27

asked May 07 '21 at 18:57

עילי גזית

What error do you get? we need more info then it only works sometimes. – Scott Craner May 07 '21 at 18:59
It would also be useful to know what the formula your code should write is. (i.e. the desired result) – cybernetic.nomad May 07 '21 at 19:03
I get a error 1004 massage :application defined or object defined. I want to define a formula cell by sum of range of cell. The error is probably because problem in the range... – עילי גזית May 07 '21 at 19:29
You need to qualify the `Cells` calls inside the `Range` with the worksheet. – BigBen May 07 '21 at 19:31
How to qualify the cell? why sometime its work and sometimes its not? – עילי גזית May 07 '21 at 19:34
And if you mean to write: cells(i, j). Address, its not work – עילי גזית May 07 '21 at 19:51

How to fix error 1004 in sum range of cell?

0 Answers0