I had a Grand total formula which read like:

cell.value = "=Sum(" & myrange & ")"

which generated the following cell text.

=Sum(A1,A11,A21,...)

However, this is very limited in the number of cells it
can contain.

I've now updated it to the following format.

=Sum(A1 + A11 + A21 + ....)

I believe this format is much larger than the previous
format, however, still does have a limit? Is this belief
correct?

Is there anyway around this limit other than to compute
the total in VBA and write the value to the cell?

David