Unable to enter a cell formula that sums a variable using VBA

Hi,

I am trying to sum up a variable range. This range is stored as a string variable called Name. I want the sum to be stored in cell (i,4). The following formula is giving me an error and I can't figure out why:

Cells(i, 4).Formula = = "=SUM(" & Name & ")"

My Name variable is also set up correctly (list of cells separated by commas).

Does anybody have any ideas?

Sorry if this has already been answered - did a search and nothing came up.

Well, you do show two = signs before the quotes, as well as one after.

If that doesn't solve it tell us exactly what you have for the variable Name.

Hope this helps.

Pete

Oh sorry - there are only two = signs, I copied and pasted wrong..

For the Name variable, I have "Daily!$B$1,Daily!$B$3", where Daily is the sheet name

So does Name include the quotes, or have you just put them in your post for clarity ?

What type of error is being reported ?

Pete

Hi,

Yes, the quotes are included in Name.
The error that I'm getting is: Run time error 1004 - Application defined or object defined error
I get that error when I used the same code that Ron is using.

Thanks for all the help : )