Code breaking at one line

Hi,

I know this is a long shot and I'm hoping that someone will be able to fix this without having to go through 100's of lines of script. I have a page of VBA code and basically the code runs fine until there are more than 5 instances of what I'm actually doing. If you see the excel spreadsheet attached I'm basically building up a decision tree. I select the number of branches and nodes based on a user form. Once there are more than 5 branches the code breaks. Here is the section of code that gets highlighted in the debug mode 'ActiveSheet.Cells(m1(i).point, colc).Formula = "=" & ActiveSheet.Cells(m1(i).point, colc - 1).Address & "*" & ActiveSheet.Cells(m2(tempflag).point, colc - 4).Address' but this is only highlighted in the second instance.

HTML Code: 

HTML Code: 

Is there anyway to rewrite this statement or can you suggest reasons as to why it breaks? Attached is an excel sheet with the outcome of the vba:

The message i get is ' Run-time-error '1004'

Application-defined or object-defined error

I've inherited this script and be honest I'm no VBA expert. How do I see if the formula results in an error.

The line that is now highlighted in yellow is 'Debug.Print "=" & ActiveSheet.Cells(m1(i).point, colc - 1).Address & "*" & ActiveSheet.Cells(m2(tempflag).point, colc - 4).Address'

Where in the VBE do I actually see the results are when the error occurs

The output from your first suggestion is:
$P$4
=$O$4*$L$31
$P$10
=$O$10*$L$31
$P$16
=$O$16*$L$31
$P$22
=$O$22*$L$31
$P$28
=$O$28*$L$31
$P$34
=$O$34*$L$31
$P$40
=$O$40*$L$31
$P$46
=$O$46*$L$31
$P$52
=$O$52*$L$31
$P$64
=$O$64*$L$91
$P$70
=$O$70*$L$91
$P$76
=$O$76*$L$91
$P$82
=$O$82*$L$91
$P$88
=$O$88*$L$91
$P$94
=$O$94*$L$91
$P$100
=$O$100*$L$91
$P$106
=$O$106*$L$91
$P$112
=$O$112*$L$91
$L$31
=$K$31*$H$61
$H$61
$P$4
=$O$4*$L$31
$P$10
=$O$10*$L$31
$P$16
=$O$16*$L$31
$P$22
=$O$22*$L$31
$P$28
=$O$28*$L$31
$P$34
=$O$34*$L$31
$P$40
=$O$40*$L$31
$P$46
=$O$46*$L$31
$P$52
=$O$52*$L$31
$P$64
=$O$64*$L$91
$P$70
=$O$70*$L$91
$P$76
=$O$76*$L$91
$P$82
=$O$82*$L$91
$P$88
=$O$88*$L$91
$P$94
=$O$94*$L$91
$P$100
=$O$100*$L$91
$P$106
=$O$106*$L$91
$P$112
=$O$112*$L$91
$L$31
=$K$31*$H$61
$H$61

From the script you just posted:
$P$4
31
12
$P$10
31
12
$P$16
31
12
$P$22
31
12
$P$28
31
12
$P$34
31
12
$P$40
31
12
$P$46
31
12
$P$52
31
12
$P$64
91
12
$P$70
91
12
$P$76
91
12
$P$82
91
12
$P$88
91
12
$P$94
91
12
$P$100
91
12
$P$106
91
12
$P$112
91
12
$L$31
61
8
$H$61
0
4

Thanks so much for helping thus far. Any idea how to rectify this. What should it be referring to?

Any ideas on a way to proceed? Like what I should look out for or is there anyway to trace the dependencies to the bug? Thanks again for your help, at least I have isolated the cause.

Great thanks for the suggestions. If I do require his services I'll pm you.